Urban wrote:
The same happens when
the sheet is being saved. Any way around this problem?


Why not clear the tables' formulas before saving and set them up again
on opening, after setting the calculation mode.

Of course the tables will need calculating before you see the results,
so you may not have gained anything....

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup