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.
 
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.
 

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
Locking a cell reference in a formula 1
INDIRECT function to reference a named range 2

Back
Top