Excel 2003 - fill down error

N

NT

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
 
D

Dave Peterson

It sounds like you have Excel in manual calculation mode.

Tools|Options|Calculation tab
and change it to automatic.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Auto Fill Options 1
Excel VBA 1
"Fill" Conditional Formatting? 5
Fill handle fill down alternative methods question 2
Fill down formulas in existing excel docs stopped working 1
Fill handle increments year instead of day 1
How can I transpose reference cells by Auto-fill? 3
Fill formula down for cells 74 rows apart 3

Top