We help IT Professionals succeed at work.

Microsoft Excel, migrate links to a new profile

chipsexpert
chipsexpert asked
on
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
Comment
Watch Question

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
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.