Digita
02-20-2008, 08:55 PM
Guys,
I'm working on an existing workbook. When I open it I got a message saying "This workbook contains automatic links to information in another workbook. Do you want to update this workbook with changes made in the other workbook?". I couldn't work out this problem as I had an eye check and could not locate any hyperlinks or formula references to any external excel files. :banghead:
Would there be some way to double check this by using a VBA code - ie list out all links?
Thanks & regards
kp
I'm working on an existing workbook. When I open it I got a message saying "This workbook contains automatic links to information in another workbook. Do you want to update this workbook with changes made in the other workbook?". I couldn't work out this problem as I had an eye check and could not locate any hyperlinks or formula references to any external excel files. :banghead:
Would there be some way to double check this by using a VBA code - ie list out all links?
Thanks & regards
kp