Moved spreadsheet changed link path

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

I have a spreadsheet that has 20 links that are to other worksheets within a
directory. The main file is on a network drive that is known as P:\ in our
environment. My client has linked these 20 other worksheets using P:\Finance
within the main file.

To troubleshoot a separate issue, I have copied the file locally to my c:\
drive. Now all 20 links are referencing the path c:\Finance. The folder path
is the same as the network drive, however instead of P:\ it changed to C:\.

Any idea of why? The hyperlink base in the properties of the file is empty.
Any suggestions?
 
If you copy and paste link then it will happen like that.

if you use mouse and click then the reference will be updated auotmatically.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing multiple hyperlinks 1
Linked Excel Files - Shared Server 2
Formula too long error 8
Pivot Table Source Data File Path Change 1
how to prevent excel to change hyperlink path towards external fil 3
Can a spreadsheet recognize the current directory it is in? 2
How to create absolue path link to another workbook (Excel 2003) 1
File path not working correctly 2

Back
Top