Formatting Lost in Excel 2007

Z

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
 
J

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
 
Z

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.
 
J

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.
 
Z

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.
 
Z

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.
 
K

kristain via OfficeKB.com

Follow the given instructions:
1. Click on the Format button in the Style dialog box to open the Format
Cells dialog box.
2. Click on the appropriate tab in the dialog box.
3. Make the desired changes.
4. Press OK to close the Format Cells dialog box.
5. Press OK to close the Style dialog box.
6. The new style is added to the top of the Cell Styles gallery
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top