Home |
Search |
Today's Posts |
#1
|
|||
|
|||
One formula on multiple workbooks question
I update, track and save about 80 workbooks. They all have the same format
and formulas. However, occasionally I need to change the formulas, so I have to update every workbook. Is there a way to save the formulas on one workbook and have all the others refer to the formulas on this. If so, how should I do this? |
#2
|
|||
|
|||
Josh,
If you want to actually change the text of the formulas, no. If you want to get data (stuff a formula returns, or text or numbers in a cell), use a link. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Josh M" wrote in message ... I update, track and save about 80 workbooks. They all have the same format and formulas. However, occasionally I need to change the formulas, so I have to update every workbook. Is there a way to save the formulas on one workbook and have all the others refer to the formulas on this. If so, how should I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy formula Question | Excel Worksheet Functions | |||
Multicell Array Formula and List Question | Excel Worksheet Functions | |||
How do I set up a formula with multiple criteria? | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Multiple worksheets, multiple workbooks | Excel Worksheet Functions |