Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - fill down error
Can anyone help me with this problem?
When I use "Fill-Down" (ctrl-D) and "Fill-Right" (crtl-R) to fill formulas into cells, I am getting the correct formulas, but the values are not correct. Even though each formula has different cell numbers in it, the displayed numbers in each of the filled-down-cells is identical to the first cell in the fill down column. However, if I manually enter each formula (instead of using "Fill-Down" (ctrl-D) or "Fill-Right" (crtl-R), ONLY THEN is each value correct. Also, when I change a value in a cell in a spreadsheet, any cells tied to that cell in a formula DO NOT CHANGE. I have tried reinstalling Excell 2003, but the problem persists. CAN ANYONE HELP ?!? Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - fill down error
It sounds like you have Excel in manual calculation mode.
Tools|Options|Calculation tab and change it to automatic. NT wrote: Can anyone help me with this problem? When I use "Fill-Down" (ctrl-D) and "Fill-Right" (crtl-R) to fill formulas into cells, I am getting the correct formulas, but the values are not correct. Even though each formula has different cell numbers in it, the displayed numbers in each of the filled-down-cells is identical to the first cell in the fill down column. However, if I manually enter each formula (instead of using "Fill-Down" (ctrl-D) or "Fill-Right" (crtl-R), ONLY THEN is each value correct. Also, when I change a value in a cell in a spreadsheet, any cells tied to that cell in a formula DO NOT CHANGE. I have tried reinstalling Excell 2003, but the problem persists. CAN ANYONE HELP ?!? Thank you -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 & cell fill colours | Excel Discussion (Misc queries) | |||
Excel 2003, will not let me color fill cells | Excel Worksheet Functions | |||
Auto Fill and Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) |