Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

Hi our finance team have multiple links to other spreadsheets within the current file server. We wish to migrate these to Sharepoint to offer them a solution via Extranet. Is this possible? There doesn't seem to be a migration function to relink the spreadsheets easily?

share|improve this question
Can you provide more details on your scenario? Just so that I understand this correctly does your finance team have links to spreadsheets as shortcuts on their desktops, on the SharePoint portal linking back to the spreadsheets location on the file server or have these links been defined in another system? And also, when you say the team needs access to these files via the Extranet, do you mean that you'd like to migrate them into SharePoint to allow for remote access to these spreadsheets? Any other useful information on your business scenario is appreciated. – Elena Mar 23 '11 at 9:29
The scenario is we have multiple linked spreadsheets on the file server we wish to migrate off the file server to document libraries. Unfortunately all the spreadsheets link through UNC path to the file server. I was hoping there was a script or an easy method to convert all these links to Sharepoint paths. – user3600 Jun 3 '11 at 1:28

2 Answers

up vote 0 down vote

You could try mapping a network drive (net use x: \intranet\site\doclib) to the SharePoint Document Library and then using that drive letter consistently across each user. I am not sure if there is a quick way (apart from copy and paste) to relink existing paths to the new one.

share|improve this answer
up vote 0 down vote

If you are feeling crazy and these are .xlsx files, you could write a program that would traverse through the OpenXML DOM and do a find and replace. Replace \\server\finance\stuff with http://sharepoint/site/subsite/finance/stuff or where ever you decide to put it. I haven't done that programmatically yet, but I have opened a .xlsx with WinZip and manually edited the XML before. Here is a link to the Open XML SDK if you need help getting started with that.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.