O
oliver
in excel, when i drag the formula it gives the same value with the reference
eventhough the succeding numbers are deferent.
eventhough the succeding numbers are deferent.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Oliver,
Can we see this formula?
Mike
Can we see this formula?
Mike
A
Ashish Mathur
Hi,
You may have absoluted the reference in your formula by using the $ sign.
--
Regards,
Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
You may have absoluted the reference in your formula by using the $ sign.
--
Regards,
Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
A
Arvi Laanemets
Hi
Set calculation to automatic, or press F9 to recalculate manually.
Set calculation to automatic, or press F9 to recalculate manually.
J
jambun
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
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
R
Roger Govier
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.
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.