Microsoft Excel, migrate links to a new profile

We are migrating to a Citrix platform. Right now all Excel files are stored on the file server. We have links between Excel spreadsheets. If I open Excel on Citrix and open the file off the file server, it tells me the links cannot be find and we need to reestablish them. Wouldn't mind but there are 75 links. Is there anyway to migrate the links?

Thanks
LVL 2
chipsexpertAsked:
Who is Participating?
 
Shanan212Commented:
One way is to open the excel file and doing a 'find & replace' for link

eg:

say a link is

'\\fileserver\name\name\file.xls'sheet1...

do a find and replace for

\\fileserver\name\name\
to
new location
0
 
Elton PascuaCommented:
Some suggestions:

1. Try to follow the same folder structure on the new location.
2. If your users have used mapped drivers, try to use the same letter and point to the same sub directories.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.