D
DigiWongaDude
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
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