Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Source data in a formula
I have a workbood template for accounting purposes that has thousands of
formulas that reference another workbook in another file. I also need several copies of this template for all of our different jobs. Everytime I do a "save as" and rename the template I need to also update the formulas to look for data in different files. I have tried the find/replace option from the menu but I can't get it to work. Any help would be much appreciated. Below is an example of a formula that would need to be change a thousand times per sheet. ='S:\Andy''s Stuff\Job Materials\Waxie Building LC101\[Waxie Building LC102.xls]Materials Cost'!F14 change to: ='S:\Andy''s Stuff\Job Materials\NW Rec SG117\[NW Rec SG117.xls]Materials Cost'!F14 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Source data in a formula
Try Edit/Links, click Change and it'll change all the links to the "right"
workbook. "akimballsmith" wrote in message ... I have a workbood template for accounting purposes that has thousands of formulas that reference another workbook in another file. I also need several copies of this template for all of our different jobs. Everytime I do a "save as" and rename the template I need to also update the formulas to look for data in different files. I have tried the find/replace option from the menu but I can't get it to work. Any help would be much appreciated. Below is an example of a formula that would need to be change a thousand times per sheet. ='S:\Andy''s Stuff\Job Materials\Waxie Building LC101\[Waxie Building LC102.xls]Materials Cost'!F14 change to: ='S:\Andy''s Stuff\Job Materials\NW Rec SG117\[NW Rec SG117.xls]Materials Cost'!F14 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Update Source data in a formula
Thanks it worked great.
"Bob Umlas" wrote: Try Edit/Links, click Change and it'll change all the links to the "right" workbook. "akimballsmith" wrote in message ... I have a workbood template for accounting purposes that has thousands of formulas that reference another workbook in another file. I also need several copies of this template for all of our different jobs. Everytime I do a "save as" and rename the template I need to also update the formulas to look for data in different files. I have tried the find/replace option from the menu but I can't get it to work. Any help would be much appreciated. Below is an example of a formula that would need to be change a thousand times per sheet. ='S:\Andy''s Stuff\Job Materials\Waxie Building LC101\[Waxie Building LC102.xls]Materials Cost'!F14 change to: ='S:\Andy''s Stuff\Job Materials\NW Rec SG117\[NW Rec SG117.xls]Materials Cost'!F14 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update data source automatically | Charts and Charting in Excel | |||
how to update data displayed from a UDF when the source data chang | New Users to Excel | |||
Update a chart immediately after inputting data into data source | Charts and Charting in Excel | |||
Macro to Update Charts Source Data | Charts and Charting in Excel | |||
Chart/Source Data update problem | Charts and Charting in Excel |