Ask Experts Questions for FREE Help !
Ask
    DocMba's Avatar
    DocMba Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 22, 2008, 12:21 PM
    Memory Usage in Excel 2007
    I am trying to do simple operations (multiplication, division, cut, copy, paste, insert columns, etc.) in a large database in excel 2007 (500,000 rows x 60 columns). However, my XP machine (1gb) gives an out of memory error - I have stopped all unnecessary programs but this message keeps appearing.

    Is there any way to increase the memory assigned to this program?
    Thanks.
    NeedKarma's Avatar
    NeedKarma Posts: 10,635, Reputation: 1706
    Uber Member
    		  
    #2

    Apr 22, 2008, 12:28 PM
    Even if 1GB wasn't enough Windows would simply revert to the hard drive swap file so I'm not sure why you are getting that unless Excel only wants to do the computations in RAM (in that case add another GB). I think that you've outgrown Excel for that database and it's time to convert it to a real relational database program.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Apr 22, 2008, 12:46 PM
    Either put more RAM into your system or move the data to a real database app like Access.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Software to show memory usage in excel. [ 1 Answers ]

I want to have each application memory usage in in excel.

Allocating more memory for Excel [ 1 Answers ]

With Windows XP and Office 2003, SP2, is there a way to give Excel more memory?

Huge Memory Usage of iexplore.exe [ 1 Answers ]

While running a larger program the other day I noticed some extremely laggy behavior. At first I just thought this was due to a complicated movie that I was editing, but a quick check of the process list showed that there was an iexplore.exe process consuming a huge amount of memory. The part that...

Microsoft Excel 2003 takes more mem usage [ 3 Answers ]

Is there any way to reduce excel 2003 mem usage to be reduced? One of my applications runs fine on Excel 2000 and fails in Excel 2003 with low virtual memory capacity error. Under task manager on looking into the "mem usage" for Excel 2000 its around 30MB and in Excel 2003 its DOUBLE!! Any...

View more questions Search