| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating formulas on workbook
How do I change a formula from Oct 08 to Nov 08 in different worksheets all
at once? Example change Oct 08! reference in all formulas to May05! in all worksheets at once. The workbook contains many worksheets and it takes time to go thru each page and change it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Updating formulas on workbook
I found out how to do it. In case someone needs to know, just select all
worksheets and do a find a replace "Byron720" wrote: How do I change a formula from Oct 08 to Nov 08 in different worksheets all at once? Example change Oct 08! reference in all formulas to May05! in all worksheets at once. The workbook contains many worksheets and it takes time to go thru each page and change it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not updating | Excel Worksheet Functions | |||
| Automatically updating a workbook from a different workbook day by | Excel Discussion (Misc queries) | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| Formulas not Updating | Excel Discussion (Misc queries) | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
