Calculate Needed in Automatic Calculation?

handlit33

Board Regular
Joined
Jul 30, 2003
Messages
81
Before I start I just want to say that I've done research already on the site and couldn't find an explanation.

I'm running Excel 2003 SP1. When I copy and paste some formulas in the bottom left hand corner "Calculate" appears as if I am calculating manually. However, calculation is on automatic. Does this mean I have a circular reference? If so, why when I delete the formulas that I have pasted does "Calculate" remain?

Thx in advance!
Tim
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

handlit33

Board Regular
Joined
Jul 30, 2003
Messages
81
On second thought, is there a way to see what excel is calculating when you push f9? That way maybe I could see where the circular reference is. Or is there a tool I could download perhaps?

Thank You
 

Watch MrExcel Video

Forum statistics

Threads
1,118,734
Messages
5,573,910
Members
412,555
Latest member
mark84
Top