Check if a excel file is linked to other files

shreeram.maroo
2StarLounger
Posts: 119
Joined: 19 Feb 2016, 16:54
Location: Veraval, India

Check if a excel file is linked to other files

Post by shreeram.maroo »

Hi,

There is an option of edit links in data menu where we can see that what all external references are there in a workbook. However, can we check vice versa - I mean is it possible to check if a workbook is being used as a external reference for which other workbooks and what is the location of those other workbooks ?

User avatar
HansV
Administrator
Posts: 69393
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Check if a excel file is linked to other files

Post by HansV »

No, that is not possible (except by checking each and every workbook for links to that workbook)
Regards,
Hans

shreeram.maroo
2StarLounger
Posts: 119
Joined: 19 Feb 2016, 16:54
Location: Veraval, India

Re: Check if a excel file is linked to other files

Post by shreeram.maroo »

Okay, thank you :)