Reaching Excel's Limits

[ExcelAtEverything]

Hello friends,

I am working on an Excel doc in a book with more data than I've ever worked with before. I have sheets in this WB that by year's end will be clipping near the 1,048,576 max for a worksheet. I also have other sheets in the same WB which will all be doing the same. The reason is that this Excel doc that I am working on will be pulling in new data each day to be analyzed, and it's a lot of data. My sheet is already starting to hang and "think" often when I hit the enter key.

My question is... what will happen once it reaches the limit? Also, any expert advice to try to alleviate the potential issue?

Thanks!

 

[ExcelAtEverything]

Ok, so I have been up all night learning about Pivot Tables and also redoing all of my connections. I went the route RoryA mentioned, where I'm using a data model connection to access my data, which is stored in folders. I reworked a lot of things in my sheet, and built up a couple of quick Pivot Tables to get myself accustomed to building them. I have to say that this is pretty amazing. The sheet is SUPER-fast now, and the file size is considerably smaller. I just need to keep learning more about Pivot Tables. I'm still not quite making the connection (no pun intended) of how to use the Pivot Table to grab the numbers I need. Like when I have an expandable PT that shows sales by date. I guess in order to access the sales totals for the month of May (for instance), I'll need to keep the PT in a fully expanded state, because otherwise the data is collapsed and has no cell address for me to reference? So I'm thinking that I'll just have several fully expanded Pivot Tables located on hidden tabs so that I can grab the data? I'll start another thread when I run into issues that I need help with.

Thanks so much to RoraA, Tupe77, Michael M, OffTheLip, and Diddi (great advice on this topic elsewhere). You people are so awesome. What a wealth of knowledge. I also apologize for the times when I let my frustrations get the best of me. I'm in an incredibly stressful life situation right now, and you all have helped me more than you can ever imagine. ?????