Formula Won't Work after 10 Cells
 

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.

Formula Won't Work after 10 Cells
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Formula Won't Work after 10 Cells
 

Is autocalculation turned on in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 05:43:02 -0800, CommMajor
wrote:

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.

Formula Won't Work after 10 Cells
 

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

"Gord Dibben" wrote:

Is autocalculation turned on in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 05:43:02 -0800, CommMajor
wrote:

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.

Formula Won't Work after 10 Cells
 

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

On Thu, 17 Jan 2008 06:50:00 -0800, CommMajor
wrote:

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

"Gord Dibben" wrote:

Is autocalculation turned on in ToolsOptionsCalculation?


Gord Dibben MS Excel MVP

On Wed, 16 Jan 2008 05:43:02 -0800, CommMajor
wrote:

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.