Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Every morning I come into work and fire up excel and get greeted by a lovely "There is not enough memory to run excel." error. There are no other applications running and it is fixed by a reboot.

It's excel 2003 standard fully patched running on Windows XP Service pack 2?

Does anyone have any idea what is causing this problem?

share|improve this question
Memory leak? Have you checked if there actually is free memory? – Torandi Jul 24 '09 at 1:15

Here are a couple of troubleshooting steps you can take:

  1. Make sure your HD is not completely full. You can get out of memory errors if you don't have enough available HD space. (Eric Lippert has a nice blog post on this, if a bit technical).

  2. Get ProcessExplorer. Run it and sort the processes by Working Set and then by Virtual Size to see if any background processes are taking up too much memory. I know you said no applications are running, but since it happens in the morning and a reboot fixes it, it might be the case that something that is running in the background (service for example) is taking up a large amount of memory.

share|improve this answer
up vote 2 down vote accepted

Solved ... The problem is a memory leak in Visual Studio 2008 (or some add-in), it was consuming ~500MB of memory from running unit tests. Closing and re-opening it does the trick.

share|improve this answer

Switch to Excel 2010 version, which can probably give you faster performance. Also consider using PowerPivot to work with a lot more data than normal pivot table

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .