memory

  1. O

    Memory load increases to unsavable during macro use

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

    Index with small limitations

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

    Excel memory management - Small file taking huge resources

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

    Animation issue with screen updating?

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

    Lack of Memory posting Excel object to PowerPoint

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

    Create PowerPivot reports summed at high level with granular calculations

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

    Out of memory : or Just quits

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

    PivotTable grouping issue vs memory/resource issue

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

    Transferring Cell Information to VBA memory

    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...
  10. 9tanstaafl9

    Running out of resources - how do I start over/clear?

    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...
  11. ed.ayers315

    Memory/Resources; Tables verses Lists

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

    HELP!!!!! Looking for Best "Laptop" for extensive use of EXCEL

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

    HELP!!!!! Looking for Best Laptop for extensive use of excel

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

    Release memory (set object = nothing), but where?

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

    Recover workbook's default settings

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

    Deleting Rows

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

    Memory Leak when expanding data from worksheet to worksheet

    Hi, I am encoutering "Out of Memory" error when running my macro, i have zoom down to this sub that make the memory usage increase from 100,000k to over 500,000k until the error hit This sub will take around 5k data and expand to more than 150k data in another sheet. The funny thing is when...
  18. M

    Macro, Efficiency and Memory

    I'm experiencing this for the first time: I'm using Excel to import about 20,000 web pages. I've noticed that Excel started off flying: 1 page every 3 seconds. Around 1000 it was noticeably slower. Around 2000 it was pulling 1 page every 30 seconds. One thing I've been doing is stop the macro...
  19. L

    MDX Query in Excel from Olap Cube?

    Hello, Not entirely sure if this is possible... I'd like to somehow get a count of how many locations each player has scored 5 or more points in, details below. Basically there is an Olap cube set up which I do not have access to change. As a simplified example the data that I have is set...
  20. M

    SUMIFS using an OR operator

    Basically, I'm using SUMIFS, and the final criterion could go one of two ways: either EMER or APPC are valid values. Here's my formula: =SUMIFS(Data2011[Net Amount],Data2011[Internet Site],A13,Data2011[Confidence %],"B",Data2011[Ad Unit],"EMER") The last criterion, Data2011[Ad Unit],"EMER" is...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top