Forum Discussion
Derek Dawson
Sep 07, 2019Copper Contributor
update links to other workbooks
Can someone please help me to disable this permanently as I get frustrated with when making entries in a workbook it suddenly stops and on pressing enter it maximises another workbook which I then ha...
- Sep 07, 2019
nabilmourad
Sep 07, 2019MVP
- Derek DawsonSep 08, 2019Copper Contributor
Hi Nabil
Further to this query, something is still not right, when I go into Data the edit links is not available ie not highlighted I had originally thought this was because it was not linked to another workbook but have now found it still links to another workbook. I have checked the other workbooks and the edit links is not available in any of them. Forgot to mention I am using Office 2016 in case it makes any difference.
Thanks for your time
Derek
- SergeiBaklanSep 08, 2019Diamond Contributor
Links could be not only in formulas within cells, in any other objects as well - conditional formatting formulas, defined names, etc.
You may try to play with Inquire if it exists in your version of Excel. Another option is FindLink http://www.manville.org.uk/software/findlink.htm
- Derek DawsonSep 08, 2019Copper ContributorThank you for your help much appreciated