| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
mass changes in formulas
If 2003 is part of a linked file reference, use Edit | Links...
If 2003 is part of a worksheet reference, make a copy of the 2003 worksheet, and rename the original as 2004. XL will update the references correctly. If 2003 is used elsewhere, you already have solutions from other posters. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How do I change '2003' in all the formulas in my spreadsheet to '2004? --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need LV MASS formula | Excel Discussion (Misc queries) | |||
| Mass add in a column | Excel Discussion (Misc queries) | |||
| How do I mass update formulas? | Excel Discussion (Misc queries) | |||
| i have lost the small + that allows mass copy of formulas in excel | Excel Discussion (Misc queries) | |||
| MASS MAILING | New Users to Excel | |||
Threaded Mode
