Changing link target
Hi
We have a series of linked workbooks, some in subdirectories, which get copied each time we start a new project. The files do not get renamed. I'm wondering if there is anyway to get the links in the copied workbooks to update to point to the new directory they're in without resorting to opening every linked workbook. At the moment the links keep pointing back to the originating directory and have to be manually updated using the Edit Links function. We're using Excel 2007. Thanks in advance Jane |
Changing link target
Hi,
You could run a find and replace command (Ctrl+H) and enter the old directory in the Find What box and the New directoy in the Replace with box and then choose Replace All. If these links are on more than one sheet select all the sheets before you run the Replace command. If this helps, please click the Yes button. Cheers, Shane Devenshire "Jane" wrote: Hi We have a series of linked workbooks, some in subdirectories, which get copied each time we start a new project. The files do not get renamed. I'm wondering if there is anyway to get the links in the copied workbooks to update to point to the new directory they're in without resorting to opening every linked workbook. At the moment the links keep pointing back to the originating directory and have to be manually updated using the Edit Links function. We're using Excel 2007. Thanks in advance Jane |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com