If you go into the workbook options, and set calculation to manual on
the "Calc" tab, and tick, "recalculate before save".

Then go into the tools menu and select autosave (if its not there, you
can install it from the add-ins option, or download). Then just set the
autosave time to 60minutes, and it will recalculate all formulas before
saving and it won't prompt you if you uncheck the box.

Simple solution, dont know what your running on your sheet, but it
should recheck imported data too. Worth a try.


GoJo


--
gareth93
------------------------------------------------------------------------
gareth93's Profile: http://www.excelforum.com/member.php...o&userid=26578
View this thread: http://www.excelforum.com/showthread...hreadid=550248