How do I update all worksheets at startup?

  • Thread starter Thread starter kit493
  • Start date Start date
K

kit493

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?
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Absolute References and worksheets 0
combining data from multiple worksheets into one 6
Reporting on multi worksheet spreadsheet 2
Question About Importing Columns From A Datasheet to A Worksheet 4
linking two worksheets in the same workbook 6
updating Excel workbook 7
Copy data from one worksheet to another 4
How to update multiple worksheets 1

Back
Top