copy a formula.

  • Thread starter Thread starter Kieran Moloney
  • Start date Start date
K

Kieran Moloney

In excel 2003 i'm trying to fill a formula. e.g cell c3 is equal to a3/b3.
However when i fill the formula down a column the resulting calculations are
equal to the value in cell c3.
Why??
 
Hi
you probably have disabled automatic calculation. Goto 'Tools -
options - calculate' and enable automatic calculation
 
Hi Kieran...........

Check to be sure your formula does not contain "Absolute" cell references,
like

=$A$3/$B$3

Vaya con Dios,
Chuck, CABGx3
 
Kieran,

We can help you better if you tell us exactly what the formula in C3 is.
Select it and look at the formula bar. When you fill it, same story.
 
On Sat, 10 Jul 2004 20:09:42 +0200, "Frank Kabel"

:Hi
:you probably have disabled automatic calculation. Goto 'Tools -
:options - calculate' and enable automatic calculation

This is strange. I had the same problem. I thought that
auto-calculation was excel's default? Are the option settings for the
excel program or saved on a per-worksheet basis?
 
Jason

If you're wondering how it got switched to "manual"......

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>

Gord Dibben Excel MVP
 
:Jason
:
:If you're wondering how it got switched to "manual"......
:
:Excel takes the Calculation mode each session from the settings on the first
:workbook opened in that session.
:
:i.e. If you saved Book1 with calc mode in manual and opened it first, calc
:mode would be in Manual.
:
:If you saved Book2 with calc mode in auto and opened it after Book1, Book2
:would be in manual mode(Excel ignores the auto calc mode in this case).
:
:If you close Book1 before opening Book2, Book2 will be in auto calc mode.
:
:Confusing enough? <g>

Thanks Gordon, that actually clears things up if you can believe that!

Jason
 
Back
Top