View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jambun@bigpond.com is offline
external usenet poster
 
Posts: 28
Default 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.