Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 poor performance

14 Jul 2010   #1
Raves

win7 x64
 
 
Excel 2010 poor performance

I have just 'upgraded' from excel 2003.

I find that copy/paste of charts and resizing/redrawing of charts to be very slow (2-5 secs) in excel 2010. In excel 2003 these operations appeared to be instantaneous.

Is this normal? Is there a way to speed this up?

System: i5 750, 4gb ddr3, hd5850

If this is the standard level of performance, why would anyone use this product over openoffice?


My System SpecsSystem Spec
.
14 Jul 2010   #2
Capt.Jack Sparrow

Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
 
 

Quote   Quote: Originally Posted by Raves View Post
I have just 'upgraded' from excel 2003.

I find that copy/paste of charts and resizing/redrawing of charts to be very slow (2-5 secs) in excel 2010. In excel 2003 these operations appeared to be instantaneous.

Is this normal? Is there a way to speed this up?

System: i5 750, 4gb ddr3, hd5850

If this is the standard level of performance, why would anyone use this product over openoffice?
Hello !! Welcome to SF !!

I suspect it might be the add-ins that is causing the problems.

Open Excel | Go to File | Options | Add-ins |

  1. In the Add-ins box, identify the add-in that you want to enable or disable and note the Add-in type located in the Type column.
  2. Select the Add-in type in the Manage box and then click Go.
  3. Select or clear the check box for the Add-in that you want enable or disable and then click OK.
  4. I would recommend to disable all non Microsoft add-ins
If you find difficulty doing that use this utility to disable them OfficeIns: Office Addin Manager (Enable/Disable Outlook/Word/Excel Add-Ins)


Good Luck,
Captain
My System SpecsSystem Spec
14 Jul 2010   #3
Raves

win7 x64
 
 

Thx Cpt Jack. I'll give it a try. But this is on a clean install of Office 2010 - are 3rd party plugins standard with such an install?
My System SpecsSystem Spec
.

14 Jul 2010   #4
Capt.Jack Sparrow

Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
 
 

Quote   Quote: Originally Posted by Raves View Post
Thx Cpt Jack. I'll give it a try. But this is on a clean install of Office 2010 - are 3rd party plugins standard with such an install?
Yup i understand. But there are lot of software that put add-ins to Office. For example i-tunes, Adobe PDF Reader etc.

- Captain
My System SpecsSystem Spec
14 Jul 2010   #5
jibse

Windows 7 32 bits
 
 
Slow start up if solver is installed

Hello,

If add-ins are installed, start up of Excel 2010 take about 5 seconds instead of less than one. This is the case with solver for example. I haven't this problem with Excel 2007.
My System SpecsSystem Spec
14 Jul 2010   #6
Raves

win7 x64
 
 

thx jibse - i do have the solver installed. Toal weak sauce that it adds so much to the loading time. I guess I'll have to install it as required.

Also, on another forum I received the advice that I may have selected the column header instead of just the filled cells while making my chart - in fact this is true. Excel 2003 only used 65000 rows, so this 'weren't no thang' but now 2010 uses many more - so I'll also try to just select my data range instead of the entire column and see if this helps during copy/paste and redraw operations. This seems likely to me, but will report back once I test it out.
My System SpecsSystem Spec
15 Jul 2010   #7
jibse

Windows 7 32 bits
 
 

Thanks Raves,

I choose also to instal it as required. But I have also this problem with personnal xlam addin and I have now to replace this xlam by a personnal file, but I will lose my personnal buttons (create with Excel 2003). Too bad.
My System SpecsSystem Spec
15 Jul 2010   #8
Raves

win7 x64
 
 

turns out my issue was selecting the entire column as my data series. once i just selected the filled cells, load time when to 'instant' as did copy/paste and chart resize operations - thanks all.
My System SpecsSystem Spec
Reply

 Excel 2010 poor performance




Thread Tools




Similar help and support threads
Thread Forum
Poor GTX 770 SLI Performance
I recently bought a second EVGA 2GB GTX 770 SC and have SLI set up, but the performance increase I got was a lot less than expected. I ran my own little benchmark with the first mission of the BF3 campaign on Ultra settings and my average frames per second only increased about 20 from about 90 to...
Graphic Cards
Poor SSD performance
Hi, I'm using Team Xtreem S3 120 GB SSD with Win7. The intallation was performed on AHCI mode and drivers and BIOS settings seem to be ok. However I get a poor perfomance. With SATA2 connection, I believe I should get seq speeds around 200-250 MB/s. Here is what I get: Crystal Disk Info AS...
Hardware & Devices
Poor computer conditions = poor gaming performance?
First off, I didn't know whether to post this in gaming or hardware. Sorry. My question: If there is dust on the videocard and fans or other poor condtions in my computer, can it affect performance in gaming? FPS wise? Thanks, Andrew.
Hardware & Devices
Poor SSD Performance
After having rather high hopes for SSD Performance...I'm disappointed. I'm glad I got a test unit, because if I would've shelled out the cabbage for this, I'd be a little PO'd. I have an 8300 Quad Core 2.5 Intel with 4GB of RAM running W7 Pro 64 Bit. Instead of trying to clone the old drive, I...
Performance & Maintenance
Poor wireless performance
Hi, I have a Toshiba Satellite Pro 500-1QT Notebook with Windows 7 Enterprise 64bit installed. I am experiencing a really poor wireless performance with this OS, while I wasn't with Windows XP sp3. In fact what happens is that the internet connection stops working for a while, than comes...
Network & Sharing
Win 7 poor performance.
Hello, I'm new to the Win 7 community and i already have a problem. I just installed Win 7 x64 4 days ago because everyone was telling me how well it runs but i had a big surprise. The instalation was fast , after that i installed the sound driver ( because i needed the control pannel to...
Performance & Maintenance


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 11:32.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App