Changing worksheet references
Make sure the new workbook is saved. Then, you shoul be able to go to Edit -
Links, and change source to the current workbook, as opposed to an external
workbook.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Ken Warthen" wrote:
After copying worksheets from one workbook into a new one the cell references
in the new workbook refer to values in the old workbook A typical cell
reference in the new workbook might look like ='C:\Some
Directory\[SomeWorkbook.xlsm]SomeWorksheet'!$AQ$4'. The correct reference in
the new workbook should be =SomeWorksheet!$AQ$4.
There must be several hundred such references in the new workbook. Is there
some way, other than manually, to correct the references to the current
workbook?
TIA,
Ken
|