excel, please stop recalculating!

S

spacely

Board Regular
Joined
Oct 26, 2007
Messages
248
Whay does excel say in the bottom status bar "calculating"... for quite some time, just when I insert a blank row, on a new blank sheet?

Other sheets I can understand, but not this one, every time.

Dave
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
It sounds like you have a macro assigned to that sheet.
Press ALT + F11 and click on the sheet in question in the explorer and see if there is code in the RH window
 
Upvote 0
There's no code in that sheet. I even made a new sheet and it does the same thing.

There's code in other sheets that does detect manual editing through keyboard typing. But not in that sheet.
 
Upvote 0
In fact, I turned calculation off, and it takes the same amount of time to just insert a row as when it was turned on. About 3 seconds.

Perhaps something else is going on. Or, that's the normal time and I'm just noticing now?
 
Upvote 0
No...inserting a row should be fairly quick....but it definitely sounds like something id triggereing a recalc....can you upload to dropbox and post the link back here ???
 
Upvote 0
Sorry, no.

I thought maybe it was the Office update that was waiting to install.... so i let that all happen, brought the excel back open, and it still is slow.
A new book however, is fast as it should be.
 
Upvote 0
Oh, sorry....you said

A new book however, is fast as it should be.
Click to expand...
I assumed you put your data into a new book, which sounds like the way to go !!!
 
Upvote 0
I don't know about putting over 60 sheets, copied, into a new book. I'd have to do 1 at a time to see which is the offender.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Function (using VBA macro) Runs Too Frequently
Replies
4
Views
370
Alex Blakenburg
A
G
  • Question Question
Weird drag-and-drop behavior
Replies
1
Views
339
Fluff
Fluff
A
  • Solved
If a cell contains the word "Completed", then return the date/time when it changed.
2
Replies
14
Views
768
dreid1011
dreid1011
M
  • Question Question
New Excel Saving Progress Bar?
Replies
1
Views
91
Mr monkeymonkey
M
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
272
sijpie
sijpie

Forum statistics

Threads
1,223,903
Messages
6,175,279
Members
452,630
Latest member
OdubiYouth

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top