General discussion

Locked

Linking in Excel Workbooks

By nk ·
I understand that when you link workbooks in Excel, there is a path identified for the links. Is there a way to change the links path. I have linked workbooks on my local machine and then copied the workbooks over to a network drive. Upon openingthe workbooks I am asked to update the link but keep getting error messages when updating the link path. Is there a field that can be directly edited on the workbook itself?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Linking in Excel Workbooks

by DKlippert In reply to Linking in Excel Workbook ...

Go to Edit > Links.
In the Source file box, click the name of the workbook you want to update.
Click Change Source.
In the Change Links dialog box, click the workbook you want to refer to.

Collapse -

Linking in Excel Workbooks

by nk In reply to Linking in Excel Workbook ...

I have tried that but I still keeep getting error messages. I know that there are formulas that may be referencing the other worksheet but don't know how to find them. Can you help?

Collapse -

Linking in Excel Workbooks

by MikeDale In reply to Linking in Excel Workbook ...

You can use Find and Replace to search for the old Path then replace it with the new Path.

You can find the Find and Replace commands in the Edit menu.

Hope this helps

Mike Dale

Collapse -

Linking in Excel Workbooks

by nk In reply to Linking in Excel Workbook ...
Collapse -

Linking in Excel Workbooks

by nk In reply to Linking in Excel Workbook ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums