Filling formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several columns of values. I entered a sum formula at the bottom of
column A. When I fill right (using handle or Edit>Fill) the resulting value
for
all columns is the value for column A. However, when I click in the cell it
shows the correct data reference and when I double click the cell the correct
value shows up. Anyone ever hear of this problem? Thanks
 
Check that calculation is set to Automatic:

Tool>Options>Calculation

Biff
 
You must log in or register to reply here.

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 VBA 1
Excel 2003 - fill down error 1
Fill handle fill down alternative methods question 2
How do I reference a cell as a row number in a formula? 4
Want to turnoff the Auto Fill Option 2
copy cell value 3
Numbers showing Up Centered in Cell ? 1
Sum formulas won't calculate on fill-down 3

Back
Top