memory

Hi, Vlookups were taking forever so I wrote the below code to use the scripting dictionary. It works fine on smaller amounts of data but I am getting the Run time error on my "live run". I assume it is due to the size of my data. how can I fix this. My work sheets are between 250k and 350k+...

I am using Excel 2013 I have one spreadsheet that is giving me issues on my new laptop. When I go to: Conditional Formatting - Manage Rules I get an error message: Not enough system resources to display dialog It is only on this spreadsheet. I have larger spreadsheets that dont give me any...

Hi, I have been working on a model and cannot figure out how to reduce the size of the file. There are several index/match functions running, but even after I pulled out about half of them, my file size only decreased slightly. Attached is the file. Anything to help (or explain the root cause)...

Hey there, I'm trying to write a program that automatically finds and removes a set of strings (stored in one column) from a large dataset. Here's my code: Sub Redact() Dim strPattern As String Dim strReplace As String: strReplace = "[Redacted]" Dim regEx As New...

Hi Guys. I've got a workbook with a complex macro which uses multiple sheets to compile a final results sheet with tens of thousands of rows of data. My issue is that, while the macro is running, the memory (Private Working Set) for EXCEL.EXE as seen in Task Manager increases until eventually...

Hi all. I am trying to create a list of products by brand, using the Index function with Small, but it seems that my data base is too big for the memory. when i index only to row 21, then it works, but when i take it to row 1500 which I need, i get an error...

Guys I got one very annoying problem related to memory management of excel. I have one file of size 4.75 MB and it's a ".xlsm" file meaning it has some very basic general routines related to management of my various sheets. I got 275 sheets in the workbook. Whenever i am working on sheet (saving...

Hi All I’m very new to VBA and have run into a problem while adding some simple “animation” (moving images around the screen) to a system I’m developing. I have a sub which moves a specified image around the screen, I have tested this and it seems to work fine. However when I call it...

When copying and pasting MS Excel (Mac 2011) into PowerPoint, receive error "Not enough memory available to read worksheet". I saw a similar post in 2010 with no responses. Thanks for any advice

Hello,Summary of my problem: Because of memory issues, I would like to create PowerPivot Reports that are summed at a high detail level, but the calculations are done at a granular detail level. Here is a simplified version of the details of my problem: -I am using the 32 bit version of Excel...

I have a workbook, #13. It has a module called “Mass” I made some small modifications to other modules, renamed the workbook #14. I test the module “Mass” the same way, in both. It works fine in #13. It gives memory error in #14 or just plain quits. -I generate a tempform -I show it and...

So I am once again perplexed. From my data i create a pivot table. From that pivot table i "show report filter pages". On each of those pages i copy 2 of the columns and place them adjoining the new PT's. One is a % number and one is in currency. I then select the PT and the 2 new columns and...

Hello everyone, I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied into VBA...

Hi everyone. Quick question. I am trying to use VBA to subtotal a relatively small amount of information, and on one (out of a hundred or so jobs) I am failing and getting an error message saying that Excel does not have enough resources to complete the task. (And I've tried this on many very...

Hello Forum, When comparing resource needs; does a table of the same size as a list use the same memory?

Hi All, I don't know if this question is right for general discussion or Excel questions so, I have posted my request under "general discussions" and I have added a link to my thread below...

I know many of you areusing "laptops" to work on excel extensively. So, I am posting myquestion here. I am looking for a new laptop that I am going to use heavily for datacrunching, financial reporting and analysis. Can someone please guide me whatbrand and what hardware configuration do I look...

I've got the code below and i want to release memory from objCommand (set objcommand = nothing), but where can I do this? If I do it inside the "If .. Then .. End If" then it wont be executed if the if-sentence is false and I can't do it after the if-sentence because I have to make a new command...

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...

For some reason, a 200kb file that I've been using (Excel 2007) has suddenly ballooned in size to over 6mb. Upon opening, I found that all 1,048,576 rows were active in the file. It only needs to be about 190 rows. This should be a simple enough problem - highlight from 191 to the bottom...