Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Cannot sane all data and formats

A possible reason would be if your workbook contains more than (roughly)
3000 different cell formats. From memory the English error message is
something like "too many cell formats".

If that's the reason how you would go about reducing them would be dependant
on what and where you have them. You could start by deleting rows and
columns to the right and below the last cell that contains any data (not
necessarily same as Ctrl-End).

You say you have 10 identical sheets, perhaps start by ensuring as much as
possible has similar cell formats. If viable then pastespecial formats from
one of the sheets to the other similar sheets.
BUT - you'll need to be careful with your conditional formats. If possible
pastespecial your CF's from top left cell to rest of section(s) but you
might need to be more careful with relative and absolute addressing (check
them after).

Regards,
Peter T

"dilettante" wrote in message
...
Hello,
happy New Year with old questions.
I have a xls workbook of 8674 Kb with
- 10 identical sheets witha data and calculations;
- 1 sheet resuming their datas and performing further calculations;
- some sheets without any data;
- Rows have conditioal format to have them colored;
- Some columns have different font dimension (arial 6 or 8 points)

When I will save the workbook I get an like (I am Italian so this is my

the
translation):

" Impossible to save alla Data and formats added to the file filename.xls"

"To go back to the workbook without saving = cancel"
"To save without solving the problem= OK"


Grateful for any help to solve the problem!
Dilettante

--
dilettante



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
Copying formats - column widths, formats, outlining to worksheets DavidBr318 Excel Worksheet Functions 4 August 14th 09 05:03 AM
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia Data Entry India Excel Discussion (Misc queries) 0 March 31st 08 12:00 PM
Comparing Data in different formats Charlotte Howard Excel Discussion (Misc queries) 2 October 23rd 06 11:23 AM
Scientific charts: what is the best add-in or package for getting sane ones? jasonataylor Charts and Charting in Excel 7 August 23rd 06 01:52 AM
Conditional Data formats Todd Huttenstine[_2_] Excel Programming 3 December 7th 03 10:45 AM


All times are GMT +1. The time now is 10:02 AM.

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

About Us

"It's about Microsoft Excel"