| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
updating the formula when an excel file is moved.
hi there,
Today, I encounter a problem while doing my little excel files cleanup. I have 2 excel files. I will called them A and B. There are formulas in files A which link to cells in files B. When I move files B to another directory, the formulas in files A all screwed up as it cannot locate the files B. Is there any way to redo the forumlas without change the forumlas 1 by 1 ? Much appreciated. NT |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
updating the formula when an excel file is moved.
nevermind, I know what to do now. =)
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Problem with Large Excel File | Excel Discussion (Misc queries) | |||
| Someone moved my linked file | Excel Worksheet Functions | |||
| I moved a file from work to home and now my color macro does not w | Excel Worksheet Functions | |||
| auto file path update when excel sheet moved to another directory. | Excel Discussion (Misc queries) | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Linear Mode
