Excel 2007 corrupting older excel files - Help!

[Bill]

I recently upgraded a pc in the office to vista and office 2007, now
when we access an excel file it opens it fine the first time but when
you exit the file it asks about saving the changes even if we didn't
do any changes and if you answer yes then the next time you access
that file you get an error "unable to read file" and if you let it
repair the file it is screwed up completely. If you answer no to the
save then everything is fine. I haven't been able to find out what is
going on has anyone seen this before?? If I save the file in the new
format everything seems fine but we have older machines that cannot
use this format so that's not an option.

Bill

 

[Don Guillett]

Office button>excel options>save>save files in this format>select excel
97-2003

 

[Bill]

Office button>excel options>save>save files in this format>select excel
97-2003

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

Doesn't work. Infact I get the same error I do if I let it save the
file when I close. I took and opened an older file, excel 97 version,
and then promptly hit 'save as' and saved it as the same format,
97-2003, under a new name and then tried to open it and got the same
'unable to open file' error we had got the other way. Am I looking at
some kind of bug in Excel 2007???

Bill

 

[Bill]

Office button>excel options>save>save files in this format>select excel
97-2003

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

Just found out some more interesting info. Other excel files seem to
work fine and do not ask to save if just opened and closed by excel
2007.

The message requesting the file be saved talks about excel 2007
recalculating formulas so what I did it take a file open it up and do
a control-alt-f9 to force a recalculation and then exited the
workbook. It asked to save but no message about recalculating
formulas. I saved and it broke the file again so I'm guessing it is a
problem with a formula. I found out if I save the file as the new
format xlsx, then open it and resave as the older format, xls, it
seems to fix the problem. So I have a work around but I'd sure like
to know what the original problem is.


Bill

 

[Bill]

Office button>excel options>save>save files in this format>select excel
97-2003

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

Just to add more fuel to the flames, if I take the new old format file
and open it with excel 97 it opens fine and saves fine. If I then
open it up with excel 2007 it opens fine but still gives me the recalc
and save message. I can save it and it will open fine the next time
and the older excel still opens it fine. Talk about weird!!!

Bill

 

[Don Guillett]

If you like, send to my email below and I'll see what happens here.
I have xl95, xl97, xl2003 and xl2007 and the compatibility pack.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

Office button>excel options>save>save files in this format>select excel
97-2003

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

Just to add more fuel to the flames, if I take the new old format file
and open it with excel 97 it opens fine and saves fine. If I then
open it up with excel 2007 it opens fine but still gives me the recalc
and save message. I can save it and it will open fine the next time
and the older excel still opens it fine. Talk about weird!!!

Bill

 

[Bill]

If you like, send to my email below and I'll see what happens here.
I have xl95, xl97, xl2003 and xl2007 and the compatibility pack.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software





Just to add more fuel to the flames, if I take the new old format file
and open it with excel 97 it opens fine and saves fine.  If I then
open it up with excel 2007 it opens fine but still gives me the recalc
and save message.  I can save it and it will open fine the next time
and the older excel still opens it fine.  Talk about weird!!!

Bill- Hide quoted text -

- Show quoted text -

I'd love to but It's full of financial data and the boss would have my
unmentionables snipped off if I sent it outside of the office

Thanks anyway

Bill

 

[Don Guillett]

Change the data......................
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

If you like, send to my email below and I'll see what happens here.
I have xl95, xl97, xl2003 and xl2007 and the compatibility pack.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software





Just to add more fuel to the flames, if I take the new old format file
and open it with excel 97 it opens fine and saves fine. If I then
open it up with excel 2007 it opens fine but still gives me the recalc
and save message. I can save it and it will open fine the next time
and the older excel still opens it fine. Talk about weird!!!

Bill- Hide quoted text -

- Show quoted text -

I'd love to but It's full of financial data and the boss would have my
unmentionables snipped off if I sent it outside of the office

Thanks anyway

Bill

 

[Bruce Sinclair]

Change the data......................

... and see if the problem persists ?

As an aside, When the OP 'saves', is the file going into the same or a
different directory ? I wonder if there are links being broken ?

 

[Bill]

.. and see if the problem persists ?

As an aside, When the OP 'saves', is the file going into the same or a
different directory ? I wonder if there are links being broken ?

Doesn't matter. If we just 'save' the file over itself it fails, if
we save it to a new file it fails. It's boiling down to Excel 2007
recalculating the formulas defore exiting and creating a broken
file.

Just for giggles I tried loading a copy of the file, changing one cell
and exiting. Excel asked as usual to recalculate and save so I did
and it dutifully 'broke' the file again.

I think what the previous poster meant was that I change the sensitive
data on the file and then post it so my boss wont go 'Jessie Jackson'
on me

I'll give it a try and see what I can come up with and send it to him
because I'd REALLY like to figure this out.

Bill