Software

Ask something
Discussion Locked

Linking in Excel Workbooks

0 helpful
5 replies

by nk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

5 replies

by dklippert

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.

by nk

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?

by mikedale

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

This discussion is closed to new replies.