Zarch,
I am having almost exactly the same issue - in my case it occurs only after
I create a pivot table connecting to external data (both manually and
programmatically).
This behavior seems to have begun suddenly.
Did you ever find a solution?

"Zarch" wrote:

I am saving it to a local drive. If I copy the data to new workbook then it
saves straight away, however, if I copy all the worksheets and macros over,
then if hangs again - well, it may not be a total hang as if I strip out most
of the lines of data, then it does save after taking a fair while to think
about it. This is repeatable on another PC. I'm just angling for clues as to
what could potentially cause this.

"Dave Peterson" wrote:

Saved from a previous post:

When excel saves the file, it saves it as a temporary file with a funny name (8
characters--no extension) in the same folder.

If the save is successful, xl will delete the original (or rename it to its
backup name (like "backup of book1.xlk)) and if that's successful, xl will
rename the funny named file to the original's name.

If you're seeing that funny named file, then something is going wrong.

Common things that get blamed for interruptions to this process are antivirus
software poking its head in or network errors--either permissions or physical
problems.

=======
So you may want to try saving to a local drive or disable your antivirus
software to see if it works.

If one of those works, then I'd stop looking.

If neither works, can you save the same workbook on a different pc?

Maybe it's time to rebuild that troublesome workbook.




Zarch wrote:

I have a workbook which refuses to save once data has been imported. I am not
using an ActiveWorkbook.OnSave command and have tried turning everything I
can think of back on i.e. ScreenIpdating=True, EnableEvents=True,
IgnoreRemoteRequests=False, have unprotected the worksheets and macros and
unhidden all rows & columns.
Whether I try to SaveAs programatically, or via the Excel User Interface, I
sometimes get a status bar message of 'Calculating Cells 0%' - so I have
tried Application.CalculateBeforeSave = False. I have also run Windows
Update to ensure that the Verclsid.exe glitch is not the cause.
The save creates a 16KB file with a name such as 7ACA2000 or 8C805000, but
that is as far as it gets. CPU usage goes to 100% and even leaving it for
half an hour does not allow it to complete a save.

--

Dave Peterson