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.
Bookmarks