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?