×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel slow down

Excel slow down

Excel slow down

(OP)
Any idea why my Excel would be running slower?  I get files with digital oscilloscope data that have about 3000 rows of data, 6 to 12 columns.  I usually have to zero and scale the data so I create additional columns.  It used to take a couple of seconds to paste the formula into 3000 cells and let me proceed to the next operation.  Now it is taking several minutes to do the same thing.Excel is using 100% of one CPU core the whole time.

I have looked through the tools/options but I have not found anything that made a difference.   

RE: Excel slow down

I don't know what would cause that.  Sometimes I have a suspicion there can be subtle stuff within the formula structure that slows things down when copying a block with many formulas... references that cause the same cell to re-evaluate more than once.  Calc time may be quicker to copy one column at a time although that's more work... facilitated by the methods described in the other thread thread770-265235: Thought that I mastered Excel...

Side note:  If you are trying to scale for plotting purposes only, this might help:
http://home.comcast.net/~electricpete/eng-tips/PlotInteractiveRev4.xls

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Excel slow down

Try setting the calculation mode to Manual (F9). It will at least you proceed until you can figure out what the problem is.

RE: Excel slow down

Try turning off your AV software.  Any external file is bound to be scan by the AV software.  Norton can be particularly annoying in this regard.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: Excel slow down

Which version are we talking here?

If it's 2007 have you got the latest updates?

Have you installed any other new software at about the time of the slow down?


If you want to post a sample file we could check if it is slow on other computers.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Excel slow down

(OP)
Turning off automatic recalc did not help.  Doing a manual recalc happens in the blink of an eye.

It's Excel 2003 SP3.  We do the automatic update thing so it should have all the latest patches.  I have not installed any software but with the automatic updates Windoze & Office are always changing stuff on me.  I can't control it, it's all done by corporate group policy.  Same with the AV, it's McAfee, I can't turn it off.

The files are all on local network so there should not be any scanning going on but who knows.

I'll try to strip out some proprietary info and post a file.

RE: Excel slow down

If you rerun it and it is still slow, then it is not the
virus software kicking in.

RE: Excel slow down

Another thing you might try is to copy the data into a new spreadsheet.  I've had spreadsheets get a corrupted cell that has caused a lot of problems (including crashing Excel with a GPF error while running a macro.  The macro was fine, but having a corrupted cell created a lot of problems).

Unfortunately, sometimes the "fix" that shouldn't make a difference is the answer  ;)

RE: Excel slow down

Often wondered if this is something to do with the clipboard overload combined with undo capability.  I normally close Excel down, restart and it seems to work OK then.

Anyone else have a solution?
 

RE: Excel slow down

(OP)
I tried putting integers 1-3000 in column A then putting the equation A1+500 in cell B1.  Then I copied & pasted this into B1 through B3000.  It took about 40 seconds.  I swear this used to take less than 4 seconds.  Anyone care to try.  This was with a new blank file.

RE: Excel slow down

[quote[I tried putting integers 1-3000 in column A then putting the equation A1+500 in cell B1.  Then I copied & pasted this into B1 through B3000.  It took about 40 seconds.  I swear this used to take less than 4 seconds.  Anyone care to try.  This was with a new blank file.[/quote]
Less than 2 seconds.

RE: Excel slow down

(OP)
Thanks for trying that.  I didn't think it was just in my head.  I tried it again with the task manager running.  Excel is using 100% of one core and the idle process is using 98% of the other core so it is something in Excel itself.

RE: Excel slow down

(OP)
Got it figured out.  I had an add in called XL Calcs loaded that was the culprit.  I've actually had this installed for a long time without this problem.  I only use it occasionally.  If fact, I only installed it because I downloaded a spreadsheet that did press fit friction force calculations that required it.  The original version I had of the add in did not cause a slowdown or at least not a severe one.  My free license had timed out & I needed to use the press fit calcs again so I had re-registered and installed the latest version.  I just removed it and I can copy 3000 cells in the blink of an eye.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources