why does when i drag a formula in excel gives the same value?
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
On Thu, 18 Sep 2008 14:13:30 +0530, "Ashish Mathur"
wrote:
Hi,
You may have absoluted the reference in your formula by using the $ sign.
|