I had a row of formulas I wanted to copy to a separate row but retain the formulas as they were.
Excel wanted to change the formulas and update the cell references.
To keep it from doing this add a $ before the row and column reference.
So if a formula was =’4Q2011′!N6 meaning get the value from the 4Q2011 worksheet cell N6.
Make the formula =’4Q2011′!$N$6
This way when you copy it the formula will stay the same instead of what it was doing which was changing it to =’4Q2011′!N7