Unable to open saved workbook
 

Apparently Excel lets you save workbooks that can't be opened. After saving
my work and copying the 6.5meg file to another network location, I found
that Excel crashed when attempting to re-open the file (Excel has generated
errors and needs to close...). This happened on several computers. Finally,
another machine was able to open the file (on its second attempt). I
re-saved the file under another name and it ended up 1meg larger in size.
The workbook has about 10 sheets with lots of charts... Any ideas?
Everyone said, "Don't you have a backup?!" Of course the backups won't open
either.

Not sure if this will help..

But I had a similar problem a few months ago, and it turned out to be
settings for Excel that were doing it.

Open Tools/Options and have a look at the settings on each machine.

Regards
Peter

"CVS" wrote:

Apparently Excel lets you save workbooks that can't be opened. After saving
my work and copying the 6.5meg file to another network location, I found
that Excel crashed when attempting to re-open the file (Excel has generated
errors and needs to close...). This happened on several computers. Finally,
another machine was able to open the file (on its second attempt). I
re-saved the file under another name and it ended up 1meg larger in size.
The workbook has about 10 sheets with lots of charts... Any ideas?
Everyone said, "Don't you have a backup?!" Of course the backups won't open
either.

Workbook sounds like it is corrupt - It happens, hence the need for backups.
Not good that the backups don't open though. You don't mention what version
of Excel but i'm guessing 97 or 2000. Even managing to get it open and then
saving as another name isn't really going to help you there, because if the
file has problems you either need to fix them if possible or recreate the
workbook. All you are likely to have done is take the problems with you.

2002/3 each have options that may allow you to recover and repair the
workbook. Do you have access to these versions anywhere? If not, and you
want to zip the file and sent it to me I can have a go at doing that for
you. Would need to take the NOSPAM out of my email address.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Peter" wrote in message
...
Not sure if this will help..

But I had a similar problem a few months ago, and it turned out to be
settings for Excel that were doing it.

Open Tools/Options and have a look at the settings on each machine.

Regards
Peter

"CVS" wrote:

Apparently Excel lets you save workbooks that can't be opened. After
saving
my work and copying the 6.5meg file to another network location, I found
that Excel crashed when attempting to re-open the file (Excel has
generated
errors and needs to close...). This happened on several computers.
Finally,
another machine was able to open the file (on its second attempt). I
re-saved the file under another name and it ended up 1meg larger in
size.
The workbook has about 10 sheets with lots of charts... Any ideas?
Everyone said, "Don't you have a backup?!" Of course the backups won't
open
either.

Hi,
Thanks for your offer. I have Office XP at home. Should that work?
Charlie

Should do - Hit File / Open, and then on the Open button the dialog box you
will see a dropdown arrow. Click on that and choose 'Open and Repair'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Charles V. Stancampiano" wrote in message
...
Hi,
Thanks for your offer. I have Office XP at home. Should that work?
Charlie