Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links in Excel
Is there a way to maintain links when files are renamed? i.e. File A links
to file B. I want to rename file A to A2006 and B to B2006. The links still refer to file B. Any suggestions? -- haf |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links in Excel
You can use Find and Replace. It is easier to do if both files A and B
are open. Use File | Save As to save file B as B2006. Open file B again (so you now have 3 files open) . Highlight all the cells in file A containing the links to file B, and Edit | Replace (or CTRL-H). In the Find what box enter: [B.xls] and in the Replace with box enter: [B2006.xls] click Replace All. Then use File | Save As to rename file A as A2006. When you are happy that both files have been renamed and the links are working correctly, you can delete files A and B from the folder. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Creating Relative Links in Excel... | Excel Discussion (Misc queries) | |||
find and replace links in Excel 2003 | Excel Worksheet Functions | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |