fill down problem

C

cal

the spreadsheet on which i am currently working doesn't seem to fill down
properly for any formulae, when i drag the handle down.
instead it just copies the data from the original cell, rather than
calculating new values for each cell below.

any thoughts welcome.

thanks
cal
 
G

Gord Dibben

cal

Tools>Options>Calculation. Make sure your settings are on "Automatic"


Gord Dibben MS Excel MVP
 
C

cal

bang on gord - thanks mate.

cal

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
| cal
|
| Tools>Options>Calculation. Make sure your settings are on "Automatic"
|
|
| Gord Dibben MS Excel MVP
|
|
| >the spreadsheet on which i am currently working doesn't seem to fill down
| >properly for any formulae, when i drag the handle down.
| >instead it just copies the data from the original cell, rather than
| >calculating new values for each cell below.
| >
| >any thoughts welcome.
| >
| >thanks
| >cal
| >
|
 
Top