| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
group workbooks/files to make global changes?
Can this be done ?
I have several workbooks / xls files . They have the same format /setup so I would like to make a change to a formulae in one on say cell B3 and have the change be made across all the other workbooks/ files. Your help appreciated Mike |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
group workbooks/files to make global changes?
Only through VBA and opening one file at a time in turn.
See Ron de Bruin's site for assistance. http://www.rondebruin.nl/copy4.htm Gord Dibben MS Excel MVP On Fri, 12 Sep 2008 14:05:01 -0700, MikeR-Oz wrote: Can this be done ? I have several workbooks / xls files . They have the same format /setup so I would like to make a change to a formulae in one on say cell B3 and have the change be made across all the other workbooks/ files. Your help appreciated Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make global changes to charts | Charts and Charting in Excel | |||
| Excel global setting for all workbooks? Calculation Automatic | Excel Discussion (Misc queries) | |||
| How do I perform a global change within/across Excel workbooks? | Excel Discussion (Misc queries) | |||
| Global Setting For All Workbooks - Filename In Footer | Excel Worksheet Functions | |||
| Global Group | Excel Worksheet Functions | |||
Linear Mode
