memory usage

I am working on a project that has to handle large volumes of data. I can find a lot of information about how to declare and size a dynamic array in VBA but not a lot about how VBA allocates memory under the covers when you make those calls. Can anyone point me towards information in this regard?

Hi, I have a spreadsheet, file size just over 2MB, file contains about a dozen queries. Not a huge amount of data, some table joins but not overly complex. What I've started to find is that when refreshing the queries, the memory usage (looking at Windows Resource Monitor) jumps rapidly from...

Hi, I keep getting Run Time Error 7 - Out of Memory in the following code: Sub PDFandValueVersion() ' This bit of code will select the worksheets to be PDF'd Dim rng As Range For Each rng In Sheets("Config").Range("A1:A" & Sheets("Config").Range("A" &...

I have created an automated macro which takes vehicle crash data from a csv file and automatically creates pivot table,charts and compares it to the previous year. The code is approximately 1400 lines long and the data of the uploaded csv can be anywhere between 2 to 100 mb csv files with more...

Hi all, I have an single-entity OData service, with a very large (~40M rows) database behind. To improve performance, I forced my service to serve paginated data (max 50 items per page). When I navigate the endpoint url from a browser without $filter and $top, I get the first 50 rows as...

I've adjusted many settings in my workbook, but I can't remember exactly what I've changed. Is there any way to recover the workbook's default settings? My workbook has become more slow when I use it, but I can't see any big changes. Is it possible that some cells are 'in use' even though I...

Is there anyway to get this version of excel to use more memory? I have 8GB available but it seems to only use 1 GB for processing.