Thank you both for your suggestions.

I have changed my macro to check for active calculations, and wait
until these are complete before saving, but it doesn't seem to make a
difference. The save does wait approx. 1 second before beginning, but
still takes around 4 minutes.

I'm not really sure how to check for an "AutoFilter" but I will
investigate...

I do not run Outlook.

My biggest quandry is why a Save As would take less time than a Save!
I'm tempted to do a Save As with a different name, close the original
file and open the newly saved version, which deletes the original
file... but then the file name is always changing...


--
BrianDavid
------------------------------------------------------------------------
BrianDavid's Profile: http://www.excelforum.com/member.php...o&userid=29772
View this thread: http://www.excelforum.com/showthread...hreadid=494848