ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Groupings: Are There Limitations? (https://www.excelbanter.com/excel-discussion-misc-queries/214080-data-groupings-there-limitations.html)

Rebecca

Data Groupings: Are There Limitations?
 
Greetings. I have an Excel 2007 spreadsheet that contains a large amount of
data (about 40,000 rows of the stuff).

I was wondering if Excel 2007 will slow down considering (or other problems
will arise) if I insert a large number (over 5,000) grouping of various rows
(Data | Grouping | etc.)? For example, MS Word 2007 slows down and gets kind
of cranky if the file gets two large or complicated.

My question then is this (and I wish I could here an answer directly from
the horse's mouth -- Microsoft -- hence, the incredible value of the MVPs
that help us here in these forums): are there recommendations or warnings
about using too many data groupings? And if yes, how many are too many?

P.s.: my computer has a lot of RAM and a powerful CPU, so ...


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com