Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Comparing Data in different formats | Excel Discussion (Misc queries) | |||
Scientific charts: what is the best add-in or package for getting sane ones? | Charts and Charting in Excel | |||
Conditional Data formats | Excel Programming |