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?