Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Too many cell formats
I'm having difficulty understanding why there would be so many cell formats?
What purpose does this serve? "Adrian" wrote: I am wondering if there is any way for me to find out how many cell formats I am using. I know the linit is 4000 and I hve a user that uses very close to that. Is there a report or a third party app that would let me check my sheets fo this information? Thanks and Happy Holidays. |
#2
|
|||
|
|||
Actually I have exceeded the format limit and it can crash
Excel. I don't know of any way of seeing how may formats are in the file. Different formats range from shading, to a line, bold line, bold text, conditional formatting, etc... I have a file over 18,000 KB in size, used for users inputting model informtion to upload into Access. The formats make it user friendly, easy to highlight entry cells. The best thing is to have the user limmit the number of formats, (colors, lines, conditional formats) in larger files. Once they excede the limit, they may not be able to undo it and lose a lot. -----Original Message----- I'm having difficulty understanding why there would be so many cell formats? What purpose does this serve? "Adrian" wrote: I am wondering if there is any way for me to find out how many cell formats I am using. I know the linit is 4000 and I hve a user that uses very close to that. Is there a report or a third party app that would let me check my sheets fo this information? Thanks and Happy Holidays. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
what is 'too many different cell formats' reply? | Excel Discussion (Misc queries) | |||
Display actual contents of cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) |