Copy of absolute cell references DO change

[RThompson]

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?

 

[PeterAtherton]

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

 

[RThompson]

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.