Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly changing average function target cells | Excel Worksheet Functions | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
changing a cell to changing the link | Excel Worksheet Functions | |||
changing color of values bigger or smaller than target | New Users to Excel | |||
Changing target sheet name wihtin a macro | Excel Discussion (Misc queries) |