Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - font/cell formatting lost saving 2003 xls | Excel Discussion (Misc queries) | |||
Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
row color formatting lost going from 2007 to 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 - Lost Formatting | Excel Discussion (Misc queries) | |||
Lost formatting in Excel | Excel Discussion (Misc queries) |