Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the name of a referenced file
I have several excel documents all referencing one another. The set
of 8 Excel workbooks (multiple worksheets in each book) come together to create a forecasting model for our business. It was developed by someone much more savy in Excel than myself and now I need to make a change. My question is this: Here is an example of a naming convention for one workbook: "Final-DW2003 - 010603" meaning it is a final for the salesman "DW" for the year 2003 - last updated 01-06-03. I have made numberous updates to this workbook and I would now like the naming convention to indicate that it was updated in 12-11-03. So, I would like to rename the workbook to reflect that but because every workbook uses formulas and references to "Final-DW2003 - 010603" if I rename the file, I would have to re-name every formula in 8 workbooks and countless worksheets. How can I do this? Related to this question is that some changes that a manager made to the database have now caused certian formulas to reference a file on her desktop. Obviously, that works for her, but anyone who wants to look at the workbook who isn't at her computer, with her desktop files, can't view the worksheets. How do I "remap" (I am probably using the wrong term there) but how do I find what my problem is, determine how it should be written and then find every reference to her "desktop" and replace it with the proper location? Thank you for your wealth of knowledge! Colleen Confused in Milwaukee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the name of a referenced file
The second part of your post shouldn't be too hard to address. Once you get
the workbooks open on your machine you should be able to see the bad link under Edit, Links. You can select it in the list of linked files, choose "Change Source" and point to the correct file location. The first part... You could go the Edit, Links, Change Source route with each dependent workbook but an easier way is to have all the dependent workbook open in Excel, along with the source workbook, when you do a File, Save of the source workbook to its new name. Then all the links will be updated automatically by Excel. You'd have to save them all after that of course... -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet referenced in same file as variable in formula? | Excel Discussion (Misc queries) | |||
Xla file being referenced in the cell | Excel Discussion (Misc queries) | |||
Links error if referenced file not opened | Excel Worksheet Functions | |||
Missing linked file - can still be referenced but can't find it! | Excel Worksheet Functions | |||
Open delimited text file to excel without changing data in that file | Excel Programming |