Formatting Lost in Excel 2007
 

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

Formatting Lost in Excel 2007
 

Maybe...

Similar problem...
http://lounge.windowssecrets.com/ind...owtopic=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"
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

Formatting Lost in Excel 2007
 

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.


On Apr 28, 12:26*pm, "Jim Cone" wrote:
Maybe...

Similar problem...http://lounge.windowssecrets.com/ind...owtopic=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"
wrote in ...
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

Formatting Lost in Excel 2007
 

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
XX (remove xxx)




"zeetoe04"
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.


On Apr 28, 12:26 pm, "Jim Cone" wrote:
Maybe...

Similar problem...http://lounge.windowssecrets.com/ind...owtopic=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"
wrote in ...
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

Formatting Lost in Excel 2007
 

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.

Formatting Lost in Excel 2007
 

On Apr 28, 10:08*pm, zeetoe04 wrote:
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.

Formatting Lost in Excel 2007
 

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

--
Message posted via http://www.officekb.com