+ Reply to Thread
Results 1 to 2 of 2

Too many cell formats

  1. #1
    Registered User
    Join Date
    12-16-2018
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Too many cell formats

    I am using MS Excel 2010 in my company on my Dell Laptop Latitude 7480

    When I build up an Excel file from scratch, it is normal without issue. but when i gradually build up the spreedsheet by adding formulas, graphs, slices and pivot tables etc., and the file size reaches over 2M (not big though), an annoying issue start appearing - when i tried to format the spreesheet, for instance, highlight even one cell, or change the border of one cell, or even change the decimal point for a cell, a message always pops up say "too many cell formats". It happened to multiple excel files.

    the only workaround is to keep saving the file and close and reopen again. In that case i can only perform one action of the above.

    I used to use the same excel version in another company and worked on the files over 90M but never have a problem.

    I am not quite sure if the problem is associated with my own excel spreedsheet, or with the version of the Excel, or with my laptop, or with my company's corporate settings.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Too many cell formats

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 10-01-2014, 03:18 PM
  2. Too Many Cell Formats!
    By davidx in forum Excel General
    Replies: 7
    Last Post: 11-27-2013, 07:06 AM
  3. [SOLVED] PasteSpecial with number formats but without conditional formats or borders
    By bodhi808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 09:58 AM
  4. Problem copying Page formats and print formats to another workbook
    By Chrisgeni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-27-2013, 08:05 AM
  5. Copying formats - column widths, formats, outlining to worksheets
    By DavidBr318 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2005, 09:05 AM
  6. Formats: Too many different cell formats error message
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2005, 10:06 PM
  7. CELL FORMATS
    By Speedy in forum Excel General
    Replies: 0
    Last Post: 01-18-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1