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 he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Fever" wrote in message ...
|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.