Hi,

I have around 3 data tables in my workbook. Everytime, I open the workbook Excel calculates these and it really slows down the loading of the spreadsheet. Is it possible to stop this? I have buttons that enable users to recalculate data tables. So it is really not necessary to calculate them on opening.

Also, for some wierd reason, these data tables are being calculated twice on opening - any idea why? I set the calculation mode to Auto except tables on opening the workbook. I am using Excel 2003.

Regards,
Ram