Hi,

I'm encountering broken links after attempting to merge two xls workbooks
together...sigh.

a formula that was =Sales!P34
becomes:
='C:\...\abc.xls'[sales]!P34 (or some such)

locking the formula in the cell directly to the workbook it was created in.

Q: How can I make the reference to the Workbook relative? Is there something
like...

=[thisWorkbook]!Sales!P34

....not an absolute reference?

many thanks !

Paul