Errors in copying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I copy a formula from one cell for set row to the following rows' cells
I get the same result as the original cell although the formulas are changing
as they should. I am not using absolute references in the formula. I have
never seen this before while working with excel.
 
Tools>Options>Calculation.

Make sure "Automatic" is checked.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Excel VBA 1
Odd Formula copying Behavior 3
copy formulae in excel 2
Cell Reference & formula 5
Excel formula to copy/paste formula needed please. 4
Formula copying error 3
Excel Help to copy information from one row at a time to another sheet 1
Way to keep formulas unchanged when deleting rows? 9

Back
Top