Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fill handle problem XP
From time to time, the fill handle copies the orignal formula but the values
that are filled show the results of the first cell. When you click on the cells, the correct cell references show in the cell but the result is the value of the first formula. Any ideas as to what is happening? |
#2
|
|||
|
|||
Sounds as though the calculation mode is set to manual. You ought to see
the word 'Calculate' in the left portion of the status bar. Fix it by going to ToolsOptionsCalculation and checking Automatic "Kylor" wrote in message ... From time to time, the fill handle copies the orignal formula but the values that are filled show the results of the first cell. When you click on the cells, the correct cell references show in the cell but the result is the value of the first formula. Any ideas as to what is happening? |
#3
|
|||
|
|||
Hi
check tools / options / calculation and ensure it is not set to manual. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Kylor" wrote in message ... From time to time, the fill handle copies the orignal formula but the values that are filled show the results of the first cell. When you click on the cells, the correct cell references show in the cell but the result is the value of the first formula. Any ideas as to what is happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom fill problem in Excel 2003? | Excel Discussion (Misc queries) | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions | |||
A different "Fill Color" problem | Excel Worksheet Functions | |||
A different "Fill Color" problem | Excel Worksheet Functions |