| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to keyboard navigate to other cells during editing formula, when arrow keys don't work | Excel Discussion (Misc queries) | |||
| How can I get a formula to work on visible cells with autofilter? | Excel Discussion (Misc queries) | |||
| in excel, formula to work only when all cells full of data | New Users to Excel | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Help to adapt Formula syntax to work with Visible Filtered Cells | Excel Worksheet Functions | |||
Linear Mode
