ExcelBanter - Relative Cell Referencing in MS Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Relative Cell Referencing in MS Excel (https://www.excelbanter.com/excel-discussion-misc-queries/131724-relative-cell-referencing-ms-excel.html)

[email protected]

Relative Cell Referencing in MS Excel

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?

Gord Dibben

Relative Cell Referencing in MS Excel

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?

All times are GMT +1. The time now is 10:29 AM.