Please help on this Error: "Document Not Saved"

[Guest]

I have an Excel file with 8 sheets. One of the sheets (8th sheet) is the
summary of the other 7 sheets. I tried saving the whole file but it did not
save the 8th sheet, "document not saved,". I also tried to change the PC to a
new one but it is still the same. Is the data too big for excel to save it on
one file? Help please...

I am using Office 2003 Professional.

 

[Simon Murphy]

No I don't think its too big for Excel unless its over 1Gb?
This message is often caused by the network dropping and reconnecting
whilst you are working.
Try to save the file locally to you C: drive, and then either move with with
explorer or reopen in Excel and save back to the network when its calmed
down

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training

 

[Guest]

The file is saved on the local drive C: from the old PC then I tranferred
the file to a new PC hoping that i won't have any trouble saving the excel
file like I have before. On the new PC, I have two partitions,C: and E:, the
excel file is saved on drive E: and the operating system is on drive C:.

 

[Simon Murphy]

hmmm ok, try here:
http://support.microsoft.com/kb/271513

possibly anti virus?
Is it shared? Tools>>Share workbook? if so turn that off
Another possibility is it was created from a template with embedded objects,
the ref above explains
Let us know how you get on

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training

 

[Guest]

Thank you for the help!

hmmm ok, try here:
http://support.microsoft.com/kb/271513

possibly anti virus?
Is it shared? Tools>>Share workbook? if so turn that off
Another possibility is it was created from a template with embedded objects,
the ref above explains
Let us know how you get on

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training