Copy of absolute cell references DO change

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

Guest

I am copying a large number of fromulas from one workbook to another. The
formulas contain ABSOLUTE references ($k$4). Yet when I paste
special-formulas only into the other workbook, the absolute references
changes. I know they are not supposed to (as the Help file says) but they do
indeed change. Now is there a way to correct this, or am I going to have to
spend the next two days redoing these by hand?
 
I can't replicate this myself. Make sure that you paste into the same cell as
on the original workbook (from say K3 to newook k3) and see if that works.

regards
Peter
 
If I could do that, then there wouldn't be a problem. But I am combining a
series of workbooks into one. Hence there is already information in the same
place as are the locked references. I am going on the assumption that its
some glitch in the computer I am working on and doing the formulas again by
hand.
 
Back
Top