Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does when i drag a formula in excel gives the same value?
in excel, when i drag the formula it gives the same value with the reference
eventhough the succeding numbers are deferent. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does when i drag a formula in excel gives the same value?
Oliver,
Can we see this formula? Mike "oliver" wrote: in excel, when i drag the formula it gives the same value with the reference eventhough the succeding numbers are deferent. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does when i drag a formula in excel gives the same value?
Hi,
You may have absoluted the reference in your formula by using the $ sign. -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "oliver" wrote in message ... in excel, when i drag the formula it gives the same value with the reference eventhough the succeding numbers are deferent. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does when i drag a formula in excel gives the same value?
Hi
Set calculation to automatic, or press F9 to recalculate manually. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "oliver" wrote in message ... in excel, when i drag the formula it gives the same value with the reference eventhough the succeding numbers are deferent. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why does when i drag a formula in excel gives the same value?
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. -- Regards Roger Govier wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
Drag formula down | Excel Worksheet Functions | |||
How do i "drag" a formula? | New Users to Excel |