I am using excel 2007 and I appear to have continual "calculating delays", which can run for fifteen minutes. I have approximately five columns of data that can take up to 50,000 rows downward. I know this is a lot of data, but should it take that long and bog down my computer or is there a problem with my spreadsheet in how it's calculating the data? I'm just curious if anyone else has this problem or if I'm doing something wrong.. Thanks in advance
One of your calculations has the mouse cursor flying around the moon & Excel is waiting for it to return to your PC. (Just Joking)
You pnly mention how much data you have. You do not mention haw much & what type of calculations are being carried out.
Without knowing what is being calculated it is hard to say what is normal & what is slow.
Have a look at the section on Calculation speed
http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm
Excel's Calculation Process
http://www.decisionmodels.com/calcsecretsc.htm
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks