Hi,
looking for a way to change the 1 link in multiple workbooks at the same time.
I have 200 workbooks all connected to one link, as opposed to opening each workbook and editing the link. Looking for a way to do it all in one shot
Thanks
Hi,
looking for a way to change the 1 link in multiple workbooks at the same time.
I have 200 workbooks all connected to one link, as opposed to opening each workbook and editing the link. Looking for a way to do it all in one shot
Thanks
Hi partyrental,
Is your link in the central workbook to a "cell"? My suggestion depends on what you need the new link to be. If you are wanting to change the cell that these workbooks link to, open the central workbook and as many linked workbooks as possible. (Test this with 1 or 2 first to see that it works, then try to open 25 or 50, or more if your system can handle that.) Once open, change the cell in the central workbook by highlighting the original cell, and then dragging it to the new location. All of the open workbooks will auto adjust the link. Go to one of the open ones to verify that. Save and close each one, except the central one, then close that one without saving. Open more and repeat the process with more workbooks.
Squeaky
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks