Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Microsot Excel Responds too Slowly

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 27-01-2012
Member
 
Join Date: Jun 2011
Posts: 21
Microsot Excel Responds too Slowly

Hi, I have been using Excel for the past 8 years. While I like all the new capabilities of Excel 2007, I am very frustrated at the extremely slow response times when it comes to analyzing or simply manipulating large data sets. For example, I have a 130 mb file with 5 worksheets. One of them (Rawdata sheet) has around 300,000 rows with 25 columns of data and around 300,000 IF statements - the other sheets are more calculation based spreadsheets with a few sums, one pivot table, around 17,000 vlookups and 5 indirect functions. There is a macro that runs to prepare the data in a certain format which is then plugged into 2 graphs.

Now, anything I need to do with the Rawdata sheet takes inordinately long - for example - if I need to delete data from 1000 rows, and I just select these rows and press 'delete' - it takes around 5 minutes. If I do the same operation on say, 5000 rows, it takes more than 2 hours. I have tried deleting entire columns / rows and same thing happens. Even scrolling thr ough cells (sideways or up and down) takes more time as the workbook stays 'open' longer. My question is, why does it take so long to do simple operations such as Delete, scroll and Paste special etc? Saving / opening takes very long too - but I can live with those.

My laptop has 2.5 gb RAM and its a 2GHz Thinkpad T60. My calculation is set to manual and my autosave feature is also turned off. It is also saved as ..xlsm. I have read a lot of posts around how to improve macro performance and how to avoid certain types of calculation etc. - but just general manipulation of data in a large file seems extremely unwieldy in Excel 2007. I have to spend more time than I can afford to just do simple data manipulation once the file becomes large. Anyone else facing similar issues out there? Any more ideas on how to speed up general performance of Excel 2007 - whats the use of all the new space on a spreadsheet and all the new features if we get bogged down by terrible performance?

Reply With Quote
  #2  
Old 27-01-2012
Member
 
Join Date: Nov 2009
Posts: 82
Re: Microsot Excel Responds too Slowly

Some spreadsheats which I used without problems in Excel 2003 also show extremely slow response times. In my company laptop the IT boys created a"bubble"as they call it, which enables me to use 2003 Excel version next to 2007 version. It seems to me that conditional formats may cause the problem. But also big records are treated very slowly. My advice is: use Excel 2003.
Reply With Quote
  #3  
Old 27-01-2012
Member
 
Join Date: Feb 2010
Posts: 471
Re: Microsot Excel Responds too Slowly

You obviously didn't have 300,000 rows in Excel 2003. I suspect those 300,000 IF statements slow you down considerably. Either go back to Excel 2003 with its 64k row limit or figure out a way to reduce the amount of data in your spreadsheet to a more manageable number. Is all the data required for each graph? If not, separate the data and graphs into separate spreadsheets. What happens if you eliminate nine out of every ten rows, leaving you with 30,000 instead of 300,000? Your graph itself can be made up of as many points as you like, but perhaps it's still meaningful if you leave only each tenth point. Sounds like a problem for Mathcad, not Excel.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Microsot Excel Responds too Slowly"
Thread Thread Starter Forum Replies Last Post
What is the option to see special character in Microsot Excel Rish!On MS Office Support 2 07-02-2012 08:01 PM
MS Excel 2007 performs VERY slowly in windows XP Lyudmyla Windows Software 4 14-05-2011 10:10 AM
FIFA Soccer 08 game application responds slowly Sharanya Video Games 5 24-03-2010 01:30 AM
PCI cards does not responds Ricky58 Hardware Peripherals 4 14-03-2009 07:40 PM


All times are GMT +5.5. The time now is 05:28 AM.