Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Why does an Excel 2007 file lose its format when reopened?

An Excel 2007 file (e.g. File.xlsx) loses its formatting when it is reopened.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 320
Default Why does an Excel 2007 file lose its format when reopened?

You may have too many cell formats/styles. To see if that's possibly true,
click on the Cell Styles "More" arrow and see if you have a gazillion styles
showing. If that's true, you can remove unused styles by saving the workbook
as a web page, closing, reopening, save as a normal workbook.

"Chrystopher" wrote:

An Excel 2007 file (e.g. File.xlsx) loses its formatting when it is reopened.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 lose formats when opening file exported from Oracle Discov cm Excel Discussion (Misc queries) 0 October 7th 09 09:47 PM
Will I lose info when I un-install excel 2007 pttimer Excel Discussion (Misc queries) 1 April 1st 09 12:31 AM
New data automatically duplicates itself when file reopened. cheryltraining Excel Discussion (Misc queries) 1 June 16th 06 04:46 PM
Hyperlinks in Excel database don't work when file is reopened. Anne Tarctica Excel Discussion (Misc queries) 0 May 7th 06 05:03 PM
csv format drops a text character when reopened in Excel RivRunR Excel Worksheet Functions 1 July 29th 05 06:16 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"