"Too Many Formats" error

C

chrismdusa

Board Regular

Joined

Mar 20, 2003

Messages

60

• Jul 28, 2005

• #2

Sorry, specifically the error is "Too many different cell formats".

 

Upvote 0

R

Russ At Index

Well-known Member

Joined

Sep 23, 2002

Messages

706

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Jul 29, 2005

• #3

Chrismdusa,

Take a look at ......

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213904

Russ.

 

Upvote 0

C

chrismdusa

Board Regular

Joined

Mar 20, 2003

Messages

60

• Jul 29, 2005

• #4

Ok thanks, but I already saw that. What I'm wondering is if there is an add-on for Excel that will improve the 4,000 limit, and if not, does anyone know if that limit will be raised in the next Excel release? Thanks again.

 

Upvote 0

Y

yankee428

Active Member

Joined

Apr 12, 2004

Messages

348

• Sep 6, 2005

• #5

This post is long since gone, but just a side note, there is a Excess Format Cleaner utility on Microsoft.com that can help reduce number for format combinations.

 

Upvote 0

SidBord

Active Member

Joined

Aug 23, 2004

Messages

346

• Sep 6, 2005

• #6

Consistent with the information in the referenced article in a preceding post, I've been told that you can reduce the problem by formatting as many cells as you can at the same time by selecting as many cells as you can (hold down the Ctrl key) then apply the formatting. For example, to apply the same format to:
A) contiguous cells, just press on the Ctrl key and move your cursor over all the affected cells, then format them.
B) non-contiguous cells, hold the Ctrl key then select each cell separately, then format them all at once.
You can do this to cells already having the same format. Just reapply the format en masse. It should help.

 

Upvote 0

SidBord

Active Member

Joined

Aug 23, 2004

Messages

346

• Sep 7, 2005

• #7

I downloaded the format cleaner you recommended, but Nothing seems to execute. The instructions on Microsoft.com said to doubleclick the .xla file to run it. I did, and I got a blank Excel screen and no macros or instructions...nothing. Has anyone actually used this program? I have it residing in the Microsoft Add-ins folder and it appears in the addin managers list, so I checked the box, but its name never appeared in the Tools list.

 

Upvote 0

Y

yankee428

Active Member

Joined

Apr 12, 2004

Messages

348

• Sep 8, 2005

• #8

I just added it as an addin, then I have a new option off the File menu. This utility resets the END+HOME cell and removes excess unused space onyour sheets.

I have also found another tool that is good for this,

http://www.appspro.com/Utilities/ExcelUtilities.htm

after running the .exe you have a new menu item, Utilities. Go Utilities, Sheet Utilities, Delete Unused styles. It takes a long time for big files (25min), but it worked very well for my case, I we are no longer getting the Too Many Formats error.

 

Upvote 0

C

chrismdusa

Board Regular

Joined

Mar 20, 2003

Messages

60

• Oct 31, 2005

• #9

Thanks yankee428 & SidBord for the info. I haven't checked this thread in a couple of months. I'll try your ideas later this week or weekend. Thanks again.

 

Upvote 0