I maintain a financial spreadsheet to which I add rows whenever new transactions occur and it has grown to a current size of 3783 rows by 13 columns. Suddenly, its pivot table refreshes and filters are not working correctly. Through trial and error, it seems that spreadsheet size is the root cause: When I “Change Source Data” to a smaller range of rows, the pivots work again. (BTW, I have 16GB of RAM so I know that cannot be my problem).
Any ideas (like a setting within Excel 2010 that I may be overlooking) other than breaking my spreadsheet into smaller pieces?
Thanks to all who reply!
Dan
Any ideas (like a setting within Excel 2010 that I may be overlooking) other than breaking my spreadsheet into smaller pieces?
Thanks to all who reply!
Dan