Excel cell reference on multiple worksheets 1

[jferrante]

I use several spreadsheets that reference formulas and numbers on each other. These are all stored on a file server.

The company moved the Excel files to a different named file server, now none of them work correctly. They are looking for the referenced spreadsheets on a location that no longer exists. Excel apparently embeds the spreadsheet name like \\server3\spreadsheet.xls.

I've tried manually changing the location reference, but it doesn't seem to work. Any ideas to correcting this problem?

Thanks in advance

 

[Gavona]

Edit, links, change source


Gavin

 

[jferrante]

Thank you, I will try that.