Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update all worksheets at startup?
I have an interlinking network of 150 to 200 worksheets for pricing which
changes daily. Is there a way to automatically update all sheets at startup without actually opening each and every worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update all worksheets at startup?
The workbook will automatically update every sheet if the workbook is set to
automatic mode. If in manual mode again all the worksheet will update at one time when you press F9. To change mode from manual/automatic go to worksheet menu Tools - Option - Calculation "kit493" wrote: I have an interlinking network of 150 to 200 worksheets for pricing which changes daily. Is there a way to automatically update all sheets at startup without actually opening each and every worksheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I update all worksheets at startup?
You do not "open" worksheets.
You merely activate them by clicking on the sheet tab. Perhaps you mean workbooks? Please clarify. Gord Dibben MS Excel MVP On Tue, 26 May 2009 10:51:01 -0700, kit493 wrote: I have an interlinking network of 150 to 200 worksheets for pricing which changes daily. Is there a way to automatically update all sheets at startup without actually opening each and every worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
Startup Prompt to update Links | Links and Linking in Excel | |||
Startup prompt - Update links | Excel Discussion (Misc queries) | |||
Excel startup and named worksheets | Excel Discussion (Misc queries) | |||
Update another worksheets | Excel Worksheet Functions |