A
Anson
I have created a spreadsheet with multiple usering entering data to it. One problem is that some people use say "Vlookup" function to populate that workbook but forgot to enter get rid of the link before saving. So every time when I open the workbook I get this annoying popup to ask me if I want to refresh the linked cells. I have tried to find them by using search on ":\" to locate some links but there are more than 10 sheets in it and it could take some time to go through each one. Also, some fields contain the directory of a file. So is there a better way to find those links? I am still using Excel 97. Thanks.