Memory management

[SueKi]

Hi! I have a large database of inventory history - at 213k lines right now - that I have a bunch of pivots and tables set up to analyze and report. It's getting very bogged down. Not sure it it's Excel or my work pc, very much suspect the latter since Excel should handle a lot more lines of data than I have.

If I take the tab with all the data, and move it to a new book, will that help? It should automatically link everything, I think, but will that actually help the problem, or will it add to it having to work across workbooks? I'm a bit nervous about the 'just try it' method. Finally all set up and reluctant to mess it up if the change causes a crash.

 

[6StringJazzer]

Excel should handle a lot more lines of data than I have.

It certainly has the size capacity, but why do you believe that the slow performance indicates something is wrong? I don't know the details of your file but calculations on 213K rows of data are not especially fast, even if a worksheet can hold over a million rows. And pivot tables can be slow for large values of "bunch".

Did you notice a sudden drop in performance, or has it been gradual as your data has grown?

 

[SueKi]

It certainly has the size capacity, but why do you believe that the slow performance indicates something is wrong? I don't know the details of your file but calculations on 213K rows of data are not especially fast, even if a worksheet can hold over a million rows. And pivot tables can be slow for large values of "bunch".

Did you notice a sudden drop in performance, or has it been gradual as your data has grown?

I had to change data sources and new file with 2021 to YTD 2022 in it, my old file had 2020 to YTD 2022 - a full years additional date and had less performance/response time issues. What concerns me the file constantly getting held with a message 'Excel has stopped working'. So far it eventually clears, but with less data I'm not sure why it's happening and I worry about the file corrupting. Maybe I do expect too much.....