why does when i drag a formula in excel gives the same value?

  • Thread starter Thread starter oliver
  • Start date Start date
O

oliver

in excel, when i drag the formula it gives the same value with the reference
eventhough the succeding numbers are deferent.
 
Hi

Set calculation to automatic, or press F9 to recalculate manually.
 
Microsoft seems to have done an automatic upgrade to office, I have
noticed that all calculations default to manual calc these days, and
have for the last week or so. You need to go into Tools/Options and
change your sheet to auto calc, I find that you need to do this on
every sheet that you do new calculations in. Why fix something that
aint broke
EJ
 
Hi

As far as I am aware, there has been no such change by MS.
The default setting for Calculation is picked up from the first file opened
in an Excel session.
I would think that you have recently started opening a file which has been
saved in manual calculation mode as your first file.
 
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

drag a formula downa column keeping one value the same? 2
Excel Drag autofill only part of formula 3
using the =page! feature to transpose a row to column 0
Copying formulas across columns 2
when I drag a formula to other cells the reference is the same 1
Dragging a formula in a column 1
INDIRECT function to reference a named range 2
formula won't change correctly when dragged 4

Back
Top