Too many cell formats

[Migasi]

Hi,

I have been experiencing this issue today and I do not know what I have done to cause it. Could you help me resolve it?

I started a new Excel Workbook with one spread sheet and then copy and paste a few columns from another spread sheet to this new spread sheet. There are no formulas/functions in both spread sheets - just names and dates.

First I was not able to CTRL C and CTRL V from one spread sheet to another. The error message was "Too many cell formats". I got around this by right clicking and chose to paste to destination format.

Next, when I tried to highlight a cell using the "bucket" icon located at the top right ribbon, I get a warning message "Too many different formats". Column A is Text format, columns B to AB are all date formats dd/mm/yy.

What is causing this issue and how can I resolve it?

Many thanks

Regards,

Migasi

 

[RoryA]

Welcome to the forum.

Try running this:

Sub CleanStyles()
    Dim oStyle As Style
    
    For Each oStyle In ActiveWorkbook.Styles
        If Not oStyle.BuiltIn Then oStyle.Delete
    Next oStyle
End Sub