Formula Won't Work after 10 Cells

[CommMajor]

Hi,
At my job we do reports where there is a list of 10 items that use formulas.
These 10 work great, but if we add any more to the list and copy down the
formulas, the formulas don't work! Has anyone ever heard of this before? Any
suggestions? We keep having to manually calculate what the formulas should
be. Thanks in advance.

 

[Don Guillett]

As always, post your formula and exactly describe, with examples, what you
are trying to do.

 

[Gord Dibben]

Is autocalculation turned on in Tools>Options>Calculation?


Gord Dibben MS Excel MVP

 

[CommMajor]

Under Tools>Options>Calculation there is a check in the box "automatic" under
calculation. What does that mean? Thank you.

 

[Gord Dibben]

I was asking because I thought perhaps the first 10 cells had been entered with
autocalc enabled then it was disabled before you added the new formulas.

Perhaps you could post a sample of your formula(s) and a sample of "items" that
won't calculate.

When you say "manually calculte" how do you mean?

F2 then ENTER?

Maybe the new items look like numbers but are actually text.


Gord