Hi
I have copied three sheets from one workbook into another and cannot update the links associated with the pages I have copied.
When I try and change the source of the links I get the following error message;
Your formula contains an invalid external reference to a worksheet.
Verify the path, workbook, and range name or cell reference are correct and try again.
I have verified these and still cannot change the source
I have also tried searching for the link using the search function in formula and cells and connot find where the link is
Please please does anyone have any ideas?
I have copied three sheets from one workbook into another and cannot update the links associated with the pages I have copied.
When I try and change the source of the links I get the following error message;
Your formula contains an invalid external reference to a worksheet.
Verify the path, workbook, and range name or cell reference are correct and try again.
I have verified these and still cannot change the source
I have also tried searching for the link using the search function in formula and cells and connot find where the link is
Please please does anyone have any ideas?