"File not saved"

[gr43023]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

Here's the situation:

1) I've created a file in Excel 2008, which I'm using because the data set has ~100K rows and about 15 columns. The existing file has one pivot table and weighs in at ~20MB.
2) I copy the pivot table worksheet to a new sheet tab and edit the pivot table.
3) I try to save the revised document. The progress bar in the lower left ticks along toward 100%, then a dialog box pops up, "Document not saved."
4) Saving the document using other strategies (changing name, changing save location, changing file type from .xlsx to .xls, etc.) doesn't work, either the same error or a complete Excel crash.

Excel is a fresh install on a three-month-old MacBook Pro with 2GB installed memory, running OS X 10.5.2, no strange programs or hacks. I updated Excel using a download of 12.0.1, then repaired permissions. The file is located on the boot drive; I have no network drives other than a Time Machine drive attached via FireWire, so none of the other solutions I've found on this forum appear to be relevant.

Why can't I save my work using Excel?

 

[Pat McMillan]

Hi,

We're currently investigating another report that sounds very much like this
issue. I don't expect you to be able to share the file with us, but if you
are able to share it and put it on a web server somewhere, it would help us
investigate. Feel free to contact me directly on this:
(e-mail address removed).

Thanks,

Pat

 

[kevinkluckhohn]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I have an answer for what you can do. I ran into this problem and the
only way I was able to save the document was to "right click" (Ctrl +
Click) on the tab the data was in, and choose "Move or copy", select
the sheet you want to save in the "move/copy" dialog and you can save
it to a new book or other sheet that is open. This just saved my
butt...

Kevin

 

[ABWC]

The Move/Copy tab to another workbook method may be a bit troublesome when a
Workbook contains multiple tabs and there are inter-tab references between
them; i.e. those references may break during the time while the tabs are
separated.

I found another workaround, which seems to effectively save the document in
its current state:

1. Pick File...Send To...Mail Recipient (As Attachment)
2. email the file to yourself
3. wait for the message to arrive
4. save the attachment
5. rename the saved attachment so you can open it while the original file is
still open
6. confirm that the emailed version contains the changes you expect
7. close the original for good ("Don't Save" is your only option when
closing the original file for good)
8. close Excel and restart