Formatting Lost in Excel 2007

[zeetoe04]

Good afternoon,

I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.

We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no formatting
again!

As mentioned, the file had a ton of broken links that were removed as
we thought that was the issue but that didn't help.

I've found that if I save it as a xlsx file, it will keep the
formatting (so far) but we have people with the 2003 version of excel
that need to use the file as well.

Any help or guidance would be greatly appreciated.

Thanks,
Krysten

 

[Jim Cone]

Maybe...

Similar problem...
http://lounge.windowssecrets.com/index.php?showtopic=774151

and the solution was...
http://excelusergroup.org/media/p/4861.aspx
(free - Formats and Styles Excel add-in - no registration)
--
Jim Cone
Portland, Oregon USA



"zeetoe04" <[email protected]>
wrote in message Good afternoon,

I've spent a lot of time googling but all I really came up with is
that it may be due to links (which I have deleted) so hopefully
someone out there will have an answer.

We have a very large workbook that has been used since before 2005
that we have never had a problem with. Two months ago, we started
using Excel 2007 but had no issues. In about mid-April when opening
the file, all of the formatting is gone! So we assumed someone saved
it as the wrong file so we copied an older version of the file and
reformatted the entire thing. Saved it and reopened and no formatting
again!

As mentioned, the file had a ton of broken links that were removed as
we thought that was the issue but that didn't help.

I've found that if I save it as a xlsx file, it will keep the
formatting (so far) but we have people with the 2003 version of excel
that need to use the file as well.

Any help or guidance would be greatly appreciated.

Thanks,
Krysten

 

[zeetoe04]

The application does not work. It will remove everything but when I go
to save the file, it tells me that Microsoft Office has an error and
needs to close Excel.

 

[Jim Cone]

Your file may have corruption problems that extend beyond cell formats.
You may want to roundtrip the file thru HTML and back and see if that helps?...
SaveAs htm/html close then reopen and SaveAs .xlsx

If you do get the file squared away, you might consider keeping the file as an .xls file type.

If your file does not contain confidential info or the confidential info can be overwritten or removed,
then I would like to get a copy of the file to review. Is that possible?
--
Jim Cone
Portland, Oregon USA
(e-mail address removed) (remove xxx)




"zeetoe04" <[email protected]>
wrote in message The application does not work. It will remove everything but when I go
to save the file, it tells me that Microsoft Office has an error and
needs to close Excel.

 

[zeetoe04]

Unfortunately I cannot forward it to you. If I disable the add-on, it
would save. We'll see tomorrow if it holds the formatting.

 

[zeetoe04]

Unfortunately I cannot forward it to you. If I disable the add-on, it
would save. We'll see tomorrow if it holds theformatting.

So far so good. Thanks for the help.