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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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
Ok....so the problem is solved ??
 
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
Function (using VBA macro) Runs Too Frequently
Replies
4
Views
285
Alex Blakenburg
A
G
  • Question
Weird drag-and-drop behavior
Replies
1
Views
130
Fluff
Fluff
A
  • Question
If a cell contains the word "Completed", then return the date/time when it changed.
Replies
1
Views
301
dreid1011
dreid1011
ChrisMac1
  • Question
VBA - Compare specific data in one column on one sheet, with the same column on 4 other sheets, copy specific cells if match found.
Replies
1
Views
222
ChrisMac1
ChrisMac1
D
  • Solved
Counting Consecutive Blanks
Replies
9
Views
402
felixstraube
F

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

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