Memory Problems
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Memory Problems

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    London / NZ
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am having Memory overload problems.

    I am running a long macro process that transfers a lot of data into a consolidated workbook which involves alot of copying & pasting. Using "application.CutCopymode=false" clears the Excel clipboard of the copy data but does not effect the system memory.

    Does anyone have any advise on this problem?


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-27 02:22, dognz wrote:
    I am having Memory overload problems.

    I am running a long macro process that transfers a lot of data into a consolidated workbook which involves alot of copying & pasting. Using "application.CutCopymode=false" clears the Excel clipboard of the copy data but does not effect the system memory.

    Does anyone have any advise on this problem?

    Gidday Dognz,

    what's your free disk space there mate ? My very limited non-technical understanding is that if RAM is used up you need free disk space that can be utilised as temporary RAM....

    I notice performance degeneration when I have less than 100 megs free
    :: Pharma Z - Family drugstore ::

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    London / NZ
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i have just under 250mb of free space - I might try and free up a bit to see if performace improces.

    Cheers,

    dognz

  4. #4
    Guest

    Default

      
    Also, still on the same theme, have a look at how your machine is set up to handle virtual memory

    start
    settings
    control panel
    system
    performance
    virtual memory

    if, for arguement's sake, you have it set to manual *and* at a level of 20megs, you're in for big trouble and are probably seeing this now with your clipboard problems...

    mine's usually set to "let windows decide"

    to be honest though, I'm just guessing

    HTH
    Chris




User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com