Excel 2016 slow recalc with filters on12/27/2022 Right now, I am running this on my Home PC (a 400 MHz PII PC with 256 Megs of RAM, OS is Win2000 at SP4 maint level and Excel 2002), but it is equally slow at work (1.7 GHz Celeron with 256 MB of RAM running Win2K SP4 and Excel 2K). So for each coworker, there will be 14 * 56 = 784 Array Formulas.Ĭurrently my spreadsheet only has a single coworker defined, so I only have 784 Array Formulas, but it takes 35 seconds at 100% CPU Utilization when I press F9 (Calculate all formulas). To be safe, I doubled this number to determine the static named range size.įor each worker I have 56 columns (one for each possible task which a coworker can process). This past week they have processed about 2500 items. This spreadsheet will hold one week's worth of my coworkers' work. For each coworker, I have 14 Array Formulas using SUMPRODUCT command with up to 5 "conditions", similar to this example:Įach condition such as "user" and "task" is a static named range of 5000 cells. One of the many things I learned was how to improve my spreadsheets with Array Formulas, but today I ran into a problem on a new spreadsheet I'm building for work. Hello All: I have been lurking around for past month learning lots from MrExcel's wonderful web site.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |