Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Too Many Different Cells Format" !

Status
Not open for further replies.
OOP

OOP

Programmer
Joined
Feb 5, 2001
Messages
94
Location
SG
I'm experiencing "Too Many Different Cells Format" Error box when opening a Excel file which is saved in the network. Is it a virus? Anyone has nay idea of what is happening to the file?
:-(
 
Sort by date Sort by votes
It's rather as the box states - excel has limited capacity of user defined styles and number formats, you can grab quite a lot when you copy tables from internet or other workbooks.
You can delete user defined number format (Format>Cell and number format tab) or styles (Format>Style... window).
See thread68-454671 for VBA solutions

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bkoopers
  • Locked
  • Question Question
Problem with Excel pasting into filtered cells
Replies
1
Views
707
combo
combo
N1GHTEYES
  • Locked
  • Question Question
Count range overlap cells
Replies
3
Views
840
N1GHTEYES
N1GHTEYES
BugZap13
  • Locked
  • Question Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
1K
bs6600
bs6600
techguy2010
  • Locked
  • Question Question
Excel macro to send e-mail to multiple agents with a different body for each
Replies
3
Views
1K
techguy2010
techguy2010
scubafrog79
  • Locked
  • Question Question
Formula for checking cells for value and then subtract value
Replies
8
Views
856
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top