Calculate at bottom of screen does not go away

  • Thread starter Thread starter Fever
  • Start date Start date
F

Fever

I am building a spreadsheet from scratch and when I add a formula and copy it
down the calculate appears on the bottom of the screen and does not go away.
It is not a circular reference. I do have a pivot table and vlookups off of
the pivot. I am using formulas for 20,000 rows. The vlookups casue it to
calculate but it then goes away. When I add the choose statement and copy it
down to the 20,000 rows the calculate appears at the bottom and does not go
away.
 
Look here:

http://www.decisionmodels.com/calcsecretsf.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am building a spreadsheet from scratch and when I add a formula and copy it
| down the calculate appears on the bottom of the screen and does not go away.
| It is not a circular reference. I do have a pivot table and vlookups off of
| the pivot. I am using formulas for 20,000 rows. The vlookups casue it to
| calculate but it then goes away. When I add the choose statement and copy it
| down to the 20,000 rows the calculate appears at the bottom and does not go
| away.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation appear on status bar when in autocalc mode 4
Sumif does not calculate beyond 1000 rows 7
Calculate in bottom left corner 1
Index/Match vs VLookup? 4
Function to display details? 1
"calculate" at bottom of worksheet 11
Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" 2
why does the word calculate show up in my Excel status bar? 2

Back
Top