"We cant connect to file" as I open excel workbook
When I open a particular excel workbook I am getting the message "We cannot connect to http://www.stackoverflow.com/test/testfile.xls'. Please make sure you are using the connect web address".
I cannot find this file in File->Edit Links. Where can I find this trouble file and turn it off? I hate seeing this popup each time I open the workbook.
Thanks.
Solution 1:
You can use a free add-in written by veteran Excel MVP Bill Manville to find links in formulas, data validation, named ranges, etc. Download from
https://manville.org.uk/software/findlink.htm