Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel eating up memory!!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm not sure if anyone out there is familiar with PI-Processbook, or PI-Datalink, or PI-Batchview... But here's my prob. I've created an excel app that uses PI-Datalink and PI-Batchview to capture data. From there, I do calculations on the data. I also have an automatic refresh built in through the Application.Ontime event (refreshes sheet range every five secs). When I look at how much memory my excel app is using through task manager (this app will run in xl97 & 2000, on win NT & 2000) it's using up to 18 or 19 mg of memory. Upon startup, it's using 12 or 13 mg. Is this ordinary, I don't think it is??? Please help....

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Richland, Washington
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Charlie -
    Does the spreadsheet run OK otherwise? Are there any other symptoms?

    I have a spreadsheet that receives data downloads from another app, and does updates (calc's and macros) triggered by a worksheet change event (when the data downloads). If the PC is taxed from some other activity, the macro's spontanously pause. This is a W98 symptom, and it doesn't occur on a W2000 machine. I suspect a memory-management problem, but that's speculation.
    Tom

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It does not have other symptons per say, other than the ones directly related. Other tasks cannot be performed at the same time. This app is going to be running on workstations that are low on physical memory to begin with, 32 mg. Trying to copy to the clipboard for example creates an "Out of Memory" Windows error. This is in excel 97 on win Nt 4.0. I am doing calls to text files and access databases, but I've gone through the code and can assure you everything is being cleaned up properly... Any other ideas?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    A bit l;ate buty this might help all who read

    In the trade thisis called dirty memory! that means Windows is comfused (not hard i know)

    To cure it is simple. save the file can cold boot (that means switch off amke a nice coffe and reboot on return) that way all locked memory data will be lost, ie clipboard will be dead.

    Windows sometimes has a nack of not dropping clip data from memory. In XP you have 8 clips or is it six?? which all allow different clips, nice! so it not the same but pre XP this is common place.

    CAUTION Office or should i say Excel XP only runs on Windows XP no other OP's and demends goods PD specs

    also this can be highlighted by Prirate if you running E2000 on win 95 or 98 ??? whos that they never shipped together, so i guess you must have spend 650GPB or 1000USD to buy, ermmmm

    this will also haoppenas these versions are not ment to be, work they will but someday soon they will conflict and be a pain.

    Always use correct versions with compatible OP's, and patch is a must SR1 and 2 and so on.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

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
  •