Paste Link with Absolute reference

[ash.mak]

Hi All,

I have about 43 workbooks. Each have 11 tabs. I am trying to create a new book which has a copy of tab#2 from each book. That would make 43 tabs in new book. I tried to copy those tabs in my new book using Pastelink but it does it with out absolute reference where I want to paste link the data with absolute reference. I am using Excel 2003.

Sorry guys I am back after along time but I was in emergency and I don't even know what happened to my other 2 questions. I am lost.

 

[Andrew Poulsom]

For me Paste Link always pastes an absolute reference, eg:

=[Book4]Sheet5!$D$13

See the $ signs?

 

[ash.mak]

Is it because I am copying a110000 from workbook X, Sheet X to workbook M Sheet M?

If I past link in same workbook I do get absolute ref however paste linking from other work books gives Relative refs. Is there any feature in excel options that needs be checked/unchecked?

THANKS!