Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 06:47 PM
Jonathan Cooper
 
Posts: n/a
Default 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   Report Post  
Old December 22nd 04, 10:28 PM
Dan
 
Posts: n/a
Default

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
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
How do I get one cell to record the time another cell was changed. Reigning in Seattle Excel Discussion (Misc queries) 1 December 17th 04 08:45 PM
what is 'too many different cell formats' reply? tommy Excel Discussion (Misc queries) 4 December 17th 04 07:23 AM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 06:09 PM
copy a cell value not its function KC Mao Excel Discussion (Misc queries) 2 December 4th 04 05:30 AM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 09:30 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017