Question about Microsoft Excel for PC

1 Answer

Memory is used up by excel

When I use excel it very quickly consumes all the available memory and the computer runs slow. How can I stop this?

Posted by Anonymous on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Microsoft Master
  • 369 Answers

I don't think you can. It's a real resource hog especially if youre using 2010/13. See below.

Excel 2003 is officially limited to 1 Gigabyte (GB) of memory.
This limit appears to be a limit on the working set memory used by the Excel process, which is the memory reported by Windows Task Manager.
Although Excel 2003 has a substantially increased memory capacity, many of the individual specific memory limits listed below have not changed in Excel 2003.

Excel 2007 is limited to 2 Gigabytes of memory for the Excel process under Windows XP/Vista (Windows memory limit).
This 2 Gigabyte limit is a limit on the Virtual Memory address space. Virtual memory used by a process is larger than the working set memory reported by Windows Task Manager, so the amount of useable memory under Excel 2007 is considerably less than twice that of Excel 2003.
Because Excel 2007 (Excel12) also requires more memory to store the indexes to the increased number of rows and columns you may not be able to load larger workbooks under Excel 2007 than was possible under Excel 2003. Memory Fragmentation may also mean that it is difficult to make use of all of the available 2 GB of virtual memory.

Many of the individual memory limits listed below have been removed in Excel 2007.

Excel 2010 is available in 2 versions: 32-bit (2 Gigabytes of virtual memory) and 64-bit (8-Terabytes (which is 8000 Gigabytes of virtual memory)).
The 32-bit version has the same memory limits as Excel 2007, but the 64-bit version, when used with a 64-bit Windows operating system, will have extremely large memory limits.
Note that the different versions of Windows Vista 64-bit and Windows 7 64-bit support differing amounts of RAM.

Posted on Mar 20, 2015

Ad

4 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad
acdr

kishor khatri

  • 1913 Answers

SOURCE: "Not enough memory to run microsoft excel."

it is conflicy with win xp updates.
check your ram.
go to device amanger then advanceced increase your virual memory to 1.5 *your rammmeory.

Posted on Jan 03, 2009

hotratchet

Jac Lawrence Pimentel

  • 952 Answers

SOURCE: Not enough memory to run the program.

Hi,

Thanks for using FixYa!

How much RAM (memory) do you have? Microsoft Office uses alot of memory, especially if the office startup tray is enabled. You probably need to add more memory to your computer or you need to disable background applications.I hope this helps.
Good luck with your homework.

Have a nice day
- HotRatchet

Posted on Aug 12, 2009

JaxPlanet

Jax Planet

  • 922 Answers

SOURCE: When i open Excel or

Restart computer.
Save changes more frequently in Word/Excel.
Add more memory. (www.crucial.com)

Good luck!

Posted on Apr 18, 2011

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Recenly my internet has drastically slowed down. i am being told not enough memory. i keep history and cookies deleated.


It is possible one of the memory chips has stopped working. Certainly deleting history and cookies is good practice but internet activity creates a lot more rubbish that clogs things and slows them down. I suggest you download a cleaning program. If you are into paying for good software CCleaner pro is an excellent tool but the free version is what I have been using for several years. It will also tell you how much of your memory is working. You will be surprised just how much rubbish it clears out after only a couple of internet sessions.

I suggest you do a hard drive defrag. It takes time but it is good housework.

If your computer is just as crisp and quick to boot as usual when not doing internet stuff then it is possible your browser has been corrupted by a virus or something nasty. If your whole computer is slow it could have affected more than just the browser. Certainly carry out a full scan and do it with your virus protection and with another programme. I use Spybot, again the free version.

Maybe your hard drive is nearly full and this will cause warnings and slow things down. Try going to My Computer, right click on the icon and select properties to see how much free space you have. You might need to delete some of the programmes you don't use.

When you have completed your computer housework it will be time to try the internet again. Try doing a speed test - maybe the internet really has slowed due to a fault that has nothing to do with your computer. In this case it is your service provider you need to contact.

You could short circuit the process a bit by either taking your computer to a friend's internet connection or inviting a friend to test yours with a known healthy computer.

Oct 25, 2016 | Computers & Internet

1 Answer

How to open old Excel file.xls in Excel 2016.


Excel 2016 should be able to open older Excel files. You might find that simply restarting your computer solves the 'not enough memory and disk space' error.

Jul 25, 2016 | Microsoft Excel for PC

1 Answer

How do i keep sloping in youtube


Do you mean the video takes ages to load and then plays a bit then stops - then plays a bit more than stops?

If you do the problem could be your flash player. You might need to update your Adobe flash player. It's free, just search for Adobe flash player online.
Once that is done if it still does it then you might not have sufficent memory on your computer or a memory problem. Another reason could be slow broadband. Faults on your phone line can cause problems that you might only notice when downloading video, which takes a lot of memory. Your broadband provider might have capped your download speed. Check out one of those broadband speed testers on the internet to see what you are getting.
The faster your proccessor on your computer the more quickly the videos will load. If your computer is doing several actions at once that will slow the speed down. So you can stop them by closing programs that are running.

Feb 08, 2015 | YouTube Videos

3 Answers

I have a Lenovo 300 N200 (0769) Recently it has become very slow even though everything seems fine. I tried running defragmentation but on a check it said defrag not needed as there's a lot of empty...


The slow reason may be one or more problems acting together. The problem nowadays is that it is very difficult and time consuming to monitor and take care of your Lenovo PC. Even experienced users find it hard to perform such tasks on regular basis because you might need to prepare a huge amount of time and energy to deal with each issue separately.

If you want to fix the problems more efficiently, try the Lenovo speed up program, available here.

Jun 27, 2011 | Lenovo 3000 N200 0769 - Core 2 Duo T5250...

1 Answer

When i work with excel sheet then my pc running very slow


How much memory do you have if its 512MB or even less. try to upgrade your Memory to at least 1GB

another solution would be scan for viruses there could be a LOT of viruses that is eating up your computer's memory.

Oct 02, 2010 | AMD Sempron 2800+, 1.6 GHz (G54222)

3 Answers

My laptop is running slow? when im in the internet my computer runs slow


Available RAM is very important for speeding up your laptop while surfing. Check your available RAM by:

  1. Starting the Task Manager (Right click on taskbar and select it)
  2. Select the Performance Tab
  3. Compare the Physical Memory vs Commit Charge numbers.

For example, my fast computer has 3600 megs of total physical memory compared to a commit charge of 1200 megs. Meanwhile, my older, slow computer has only 650 megs of total physical memory with a commit charge of 1400 megs. This means the slow computer is always making 'pretend' memory from hard drive space, and that is why it is so slow. This is most likely the case with your computer as well.

I hope that helps.

Jul 14, 2010 | Toshiba Satellite A135-S2276 Notebook

1 Answer

My computer sporadically moves very slow and sometimes just stops for a while. Often I have to wait up to a couple of minutes to get moving again. Other days everything is normal. I probably have more...


Older computers get full of rubbish/malware/running programs and this slows the computer down soooo much. Try follow this little guide http://www.fixya.com/support/r5272277-secure_clean_computers
Adding a little more memory can also work wonders.
Windows xp like at least 512mb, vista and windows 7 like 2gb

Jul 10, 2010 | E-Machines Computers & Internet

1 Answer

Computer gets very slow by downloading anti virus....plz help me


The anti virus is needed for computer to protect from the viruses .
The anti virus consumes certain amount of cpu and memory usage.There are anti viruses that consume large amount of memory and CPU .
If your system have higher memory and CPU performance you can use any anti virus so that the performance is not downgraded to very much.

If you not having more memory and higher CPU in that case you can use anti virus that can consume less memory and also you can stop services in antivirals which are not necessary

Mar 12, 2010 | Norton AntiVirus 2004 (0003764823191)

3 Answers

100% CPU Usage


Run your anti-virus program and a spyware/malware removal tool.
A good free one is: http://www.superantispyware.com/
A good site to find what services should be running and what can be turn off is http://www.blackviper.com/WinXP/servicecfg.htm

Mar 13, 2009 | Computers & Internet

2 Answers

Computer running slow


Slow with programs or slow online?
Try holding ctrl+alt+del and click on the performance tab to see how much available memory you have.
You possibly could be infected. Try AVG free virus software. It finds them when others dont.

Dec 10, 2008 | MSI KM4M-L Motherboard

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

130 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...