Relative Cell Referencing in MS Excel

  • Thread starter Thread starter william.bonds
  • Start date Start date
W

william.bonds

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?
 
Most common cause of this is that calculation is set to manual.

Tools>Options>Calculation.

Set it to Automatic.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas with relative references 2
Fixed/Locked cell referencing 6
Absolute and Relative Cell References 1
How to copy an unreferenced cell and keep the formula 5
Excel Copy COUNTIF while retaining reference 7
Excel 2002: changing link formula from absolute to relative 3
Relative worksheet referencing 1
Excel - copy absolute cell references (within the range) as relati 1

Back
Top