+ Reply to Thread
Results 1 to 5 of 5

Basic file, no pictures, no formulas, huge memory and cpu usage

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Posts
    154

    Basic file, no pictures, no formulas, huge memory and cpu usage

    I have been having a problem with the attached file where just clicking around the file in different cells and doing nothing else uses max 50% cpu usage (2 cores i assume). It also uses 300+mb of memory. I have bigger more complicated files that use more sheets and more columns that use 10 times less memory and have hardly any cpu usage at all. I have no idea what is causing it as there are NO formulas, NO conditional formatting, NO macros and NO pictures in this file! It doesnt even use a large number of cells.

    I am using office 2010 pro 32bit and windows 7.

    Any ideas? I have attached the file in question.
    Attached Files Attached Files

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Basic file, no pictures, no formulas, huge memory and cpu usage

    There are almost 47000 shapes on the worksheet. You may use f5, Special..., Objects to select these shapes and then delete them.

  3. #3
    Forum Contributor
    Join Date
    02-09-2004
    Posts
    154

    Re: Basic file, no pictures, no formulas, huge memory and cpu usage

    goddamn thats a lot of shapes, no idea where they came from. How did you see thee are 47000? I've done f5 but a few mins later its still hammering away at it.

    thanks

  4. #4
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Basic file, no pictures, no formulas, huge memory and cpu usage

    With VBA:
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Basic file, no pictures, no formulas, huge memory and cpu usage

    I am writing this sentence because one day I could need to look this thread again

    Please Login or Register  to view this content.
    Last edited by HerryMarkowitz; 12-12-2013 at 08:59 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. File Becomes Huge When I Add Pictures
    By ecuevas in forum Excel General
    Replies: 1
    Last Post: 07-10-2007, 04:59 PM
  2. XL 2007 memory usage
    By Dave F in forum Excel General
    Replies: 5
    Last Post: 08-20-2006, 08:10 PM
  3. Why does memory usage expand so much?
    By Roland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2005, 06:05 PM
  4. [SOLVED] Monitor memory usage
    By JL in forum Excel General
    Replies: 0
    Last Post: 05-13-2005, 01:06 PM
  5. [SOLVED] Memory Usage
    By Paul Johnson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1