Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I copy and paste formulas, the relative cell referencing is not
working. It is copying the same formula all the way down and I don't have any absolutes in my formulas. What could be the problem? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Most common cause of this is that calculation is set to manual.
ToolsOptionsCalculation. Set it to Automatic. Gord Dibben MS Excel MVP On 21 Feb 2007 12:56:28 -0800, wrote: When I copy and paste formulas, the relative cell referencing is not working. It is copying the same formula all the way down and I don't have any absolutes in my formulas. What could be the problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative vs Absolute referencing of Workbooks | Excel Worksheet Functions | |||
Relative referencing in Microsoft Excel between worksheets | Excel Discussion (Misc queries) | |||
Relative column referencing within formulas | Excel Discussion (Misc queries) | |||
How do I turn off relative cell referencing in excel? | New Users to Excel | |||
macro relative referencing | Excel Discussion (Misc queries) |