Error Message - Too many different cell formats | Excel forum

Resolved · High Priority · Version 2010

Tue 13 Mar 2018, 16:21 Delegate Margaret said...

Margaret has attended:
Excel Intermediate course

Error Message - Too many different cell formats

I keep receiving the error message "Too many different cell formats" when I am trying to make some changes to a worksheet in a workbook. To get round this I have copied and pasted into a new workbook but the sheet I am working on is linked to a number of worksheets in the book so that work around wont work. Please advise.

Thu 15 Mar 2018, 12:04 Trainer Wendy said...

RE: Error Message - Too many different cell formats

Hi Margaret

Thank you for using the forum.

It looks as if this question has been posted twice and I see Marius has responded to the previous post

Please let me us know if this isn't resolved

Kind regards
Wendy Canelas
Microsoft Trainer

Thu 22 Mar 2018: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips