• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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
0
chipsexpert
Asked:
chipsexpert
2 Solutions
 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now