.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Hyperlinks embedeed in excel change when checked out in sharepoint 2007 and saved as local copies.

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :SharePoint

I have an excel folder that is used by several people.  Each has the ability to edit and save changes to track training classes they have attended.  Each person's name in column a is a hyperlink to a sharepoint folder to which is only accessible by the individual and their managers.  When a user checks out the document, they are asked if they want to open the file as a local draft.  If they select yes, when the document is saved back to sharepoint the hyperlinks have changed to the local copy of the user's workstation.  This prevents users from accessing their folders.

Can I turn off the ability to save to a local copy?  How can I prevent the hyperlinks from changing?


View Complete Post

More Related Resource Links

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Sharepoint 2007 and Excel 2010 features


Does Sharepoint 2007 Server support the new Excel 2010 feaures like slicers? Or do i have to have Sharepoint 2010 to get that working (considering all other components besides Sharepoint 2010 are available in my Sharepoint 2007 environment) ?

- Thanks



Video: Connecting PivotTables in Excel 2007 to Data Stored in SharePoint Lists

Learn how to use the Open XML SDK 2.0 to create Excel 2007 PivotTables that are connected to data stored in SharePoint lists.

Interacting with the Excel Web Services API for SharePoint Server 2007

Get a quick start with the Excel Web Services API, which enables interaction with published Excel 2007 workbooks in SharePoint Server 2007 from a remote application. Learn considerations around session state, security, and performance.

Publishing Excel 2007 Workbooks to SharePoint Server 2007 (Visual How To)

Watch the video and explore code as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

Sample: Publishing Excel 2007 Workbooks to SharePoint Server 2007

Explore the code in this visual how-to article as you learn how to publish Excel 2007 Workbooks to SharePoint Server 2007 programmatically.

[Sharepoint 2007] How can i change the email of a sharepoint user ?

Hi all,

I have created a new sharepoint user.

1. First of all i have added a new user in active directory. However at that time i forgot to give an email address. Big mistake !

I cannot send mail from sharepoint workflow with the new user.

2. Therefore I updated the email addresd in active directory afterwards. But the change was not reflected in sharepoint.

I updated the mail in sharepoint adminsitrative user profile. But it did not make no difference in the user moss profile.

I followed the article in http://sharepointnotes.wordpress.com/2008/05/05/syncing-wss-and-moss-user-profile-properties-with-active-directory/

I did the following commands :

1. stsadm -o sync
2. stsadm -o sync -synctiming m:2
3. stsadm -o sync -deleteolddatabases 6
 stsadm -o sync

None of these commands updated the user properties mail for my new MOSS User.

I also rebooted the machine but my MOSS user email was not updated.

Also I used the tool at http://userprofilesync.codeplex.com/releases/view/13227
like the following :

tool>UserProfileSync.exe -url http://mysite -ssp http://mysite:37239/ssp/admin
I did not make any difference

What else can I try in order to update the email of my MOSS user ?

Server drafts location not being saved Excel 2007

Hi, I have problem with "Server drafts location" not being remembered. And my "Server drafts location on this computer" button is not even checked but I still get the message: "The server drafts location you entered for offline editing is not valid or you do not have permission to access that location. Please specify a location on your local computer" Even if I change and choose a place for this it renders this message as soon as I for example "Adjusted List". Every thing I change in "Excel Options" renders the above message. I have full control over the "Application data" folder as well. Please see if you can help out since this is really giving me trouble in my daily work. I have Microsoft Windows XP professional sp 3 and Office 2007 latest sp. Thanks in advance! Mari

"Document not Saved" in Excel 2007 - using Windows XP Pro and Office 2007 Pro

Hello folks,   I am having an issue with all of my Excel documents saving from the network drive.  Whether I open the document then "save as" 97- 2003 or just do a straight "save" it will always come up as "Document not saved".  I open some Word files and get a different error, "There has been a network or file permission error.  The network connection may be lost (the drive contents here)"  Now I am online and can do emails and open other documents from the network so I know my network connection is not lost.  I work right off the LAN and not wireless.   I did take the file in both Excel and Word and copy them to the local drive then try the open / save as and it will work great like that no problem.  Although this is a "work around" is there something I am missing?  Our corporation has many new machines running Windows XP Pro along with Office 2007 Pro and this was the first I had seen this problem with.  This is a laptop, but again others work fine ( that I know of)   Thanks, Mark

Sharepoint 2010 and Excel 2007

i just installed sharepoing 2010 enterprise (not an upgrade) and sqlserver 2008 on another machine. everything is working well, however, i cannot open any excel documents saved in 2007 format. if i save the document in 2003 format, i can open and edit the file. this is not true for word, in which either 2003 or 2007 opens perfectly. not sure what the problem is. the error on the server is 5244. ExcelServerWebServiceApplication.Local: Could not get the web application associated with this context. This indicates that the Excel Server service is not properly registered or provisioned. is registered in event viewer.  

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

Uploading Excel 2007 table into WSS 3.0 - How does SharePoint decide the column that is used to edit

Hi, In Excel 2007, there's an option to upload (export) an Excel table into SharePoint.  The range of cells have to be identified as a table.  In the Table ribbon, there's an Export button.  When I upload the Excel 2007 table, SharePoint (WSS 3.0) decides which column in the table will be linked to the properties dialog box for each line in the table.  It seems to be a sporadic decision on the part of SharePoint. Does anyone know how WSS 3.0 decides which column will be linked to properties?  And, is there any way to control this when uploading the file? Thanks!Thanks! Patti N.

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

Unable to open an Excel File in Sharepoint MOSS 2007


I am unable to open an excel file in Sharepoint (MOSS 2007). All other documents work fine. As far as I know there was no change on the Server at all.

Excel found unreadable content in 'stuff.xls'. Do you want to recover the contents of this workgroup? If you trust the source of this workbook , click Yes

When I click YES >> It says "Excel recovered your formulas and cell values, but some data may have been lost." And then a link to an xml file , which reads :

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <summary>Errors were detected in file 'http://server_name/Project_name/Shared Documents/abc - def/Phase 5/Track/stuff.xls'</summary>
- <additionalInfo>
  <info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

Now this has resulted in huge loss of data and I can see New numbers in the cells which is very strange!

Is there a way I can get it back ? I do not have a

Cannot Publish Excel 2007 workbook to Report library on MOSS 2007 Sharepoint



I use Windows 7, trying to Publish an excel workbook to MOSS 2007 Report Library. When I type the location in the "Save As.." dialogue, It disappear & file is not saved.

If I do the same from Windows XP OS with Office 2007, I get the Report Library content (the sp folderrs), so I can navigate & file is published succesfuly

Please help :-)


Sharepoint 2010 and Excel 2007




I am creating a windows utility where user select list from a windows form combo box and inserting the excel data into the sharepoint list.

Issue that i am facing is, SharePoint runs on VS2010 project properties Platform Target as "Any CPU" while excel 2007 driver "Microsoft.ACE.OLEDB.12.0;" workins with Platform target as "x86".


Both are not working with each other, while if I am running them separately, they are working.


Kindly suggest.





Change domain AD + upgrade Sharepoint 2007->2010 = window with a request login/password


New installation of Sharepoint 2010 in Domain_A domain. I added a content database WSS_content2007 from Sharepoint 2007 (from domain Domain_B). I didn't run the command stsadm -migrateuser. New accounts from domain Domain_A were manually added to SharePoint 2010. In table Userinfo on WSS_Content2007 on Sharepoint 2010 are accounts from both domains. Old domain Domain_B was deleted.
Users get a window with a request re-enter your username and password from time to time.
What should I do? Can I delete the account from the domain Domain_B with stsadm command? Should the column tp_title contain unique records for the same user and the same site?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend