Fill handle problem XP

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

Guest

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?
 
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 Tools>Options>Calculation and checking Automatic
 
Hi

check tools / options / calculation and ensure it is not set to manual.
 
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
Filling formulas 1
Fill handle increments year instead of day 1
Fill handle fill down alternative methods question 2
Is there a keyboard shortcut to fill handle a large # of cells? 1
How To Have A Cell Be Blank If... 2
Series fill only copying and fill series greyed out 1

Back
Top