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?
:-(
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.