Bright01
asked on
Updating Links
I have copied a sheet from one workbook to another and I continue to get a "Update Links" each time I open the new WB. Although I can see that the link takes me back to the old WB, and if I break the link, I then lose some functionality in the new sheet....... is there a way to find out where the link is in the code or WB so I can fix it and then break the link?
Thank you,
B.
Thank you,
B.
If this is really time-exhausting while you are making updates, you can shut them off temporarily with:
File - Options - Advanced Tab, "When calculating this workbook " section
uncheck: Update links to other documents.
Thanks
File - Options - Advanced Tab, "When calculating this workbook " section
uncheck: Update links to other documents.
Thanks
ASKER
Slycoder,
Thanks for the quick follow up. Is there a way to scan the entire Workbook? I did a Find and included;
=+'[
But nothing came back. Do I have to do it for each sheet? What about any Macro or Range Name References?
Thank you,
B.
Thanks for the quick follow up. Is there a way to scan the entire Workbook? I did a Find and included;
=+'[
But nothing came back. Do I have to do it for each sheet? What about any Macro or Range Name References?
Thank you,
B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Dave,
Thanks for the tip. I did 1, 2 and 3 and still didn't match up with what the Link is showing me (from the Source where I copied it....but doesn't show up in any of the tabs or the Range Name Mgr.). BTW; where I have Ref errors on the Range Name, may I assume those range names are irrelivant in the new model? Anywhere else to look? If not I'm going to manually force a non-update to the sheet.
Comments?
Thanks,
B.
Thanks for the tip. I did 1, 2 and 3 and still didn't match up with what the Link is showing me (from the Source where I copied it....but doesn't show up in any of the tabs or the Range Name Mgr.). BTW; where I have Ref errors on the Range Name, may I assume those range names are irrelivant in the new model? Anywhere else to look? If not I'm going to manually force a non-update to the sheet.
Comments?
Thanks,
B.
Yes, you can delete ref errors.
Can you upload (is it sensitive info)?
Dave
Can you upload (is it sensitive info)?
Dave
ASKER
Dave,
I actually found the link...it was in a macro. I'm not sure how you find errors in macros other then look througth each of them for references.
Thank you,
B.
I actually found the link...it was in a macro. I'm not sure how you find errors in macros other then look througth each of them for references.
Thank you,
B.
ASKER
Thanks Dave,
Your tips were very good and forced me to look at the Macros which is where I found the reference.
B.
Your tips were very good and forced me to look at the Macros which is where I found the reference.
B.
without quotes:
=+'[
in formulas - this should jump you to each cell that has a sheet reference e.g.: =+'[myWorkbook.xls]Sheet1'
Thanks