View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.