LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default how to remove all formatting

I am working on office 2007 prof - my spreadsheet should be read by
colleagues using 2003 and ideally 2000 versions.
While I was able to save the file as xls in the past, I am now getting error
messages re too many formats being used. Running the compatability chequer, I
have removed conditional formatting from two columns taking care of one
listed issue. The remaining one stating too many formats does not help me.
How can I deal with it?

Is there any function to remove all formatting. My spreadsheet would look
terrible but at least everyone has access to the data in there.
Any other way to sensibly work with or in older versions.
 
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
Remove explicit formatting only Mitch Powell Excel Discussion (Misc queries) 6 September 9th 09 09:47 PM
"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." Greg Lovern Excel Discussion (Misc queries) 0 July 18th 08 09:42 PM
How to remove all formatting. Rick Wetzel Excel Discussion (Misc queries) 2 October 25th 06 02:31 AM
Remove all formatting ragtopcaddy Excel Worksheet Functions 3 February 28th 06 02:45 PM
Remove formatting from SSN Claire View New Users to Excel 3 October 9th 05 03:59 AM


All times are GMT +1. The time now is 08:29 AM.

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"