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 ?
Check if a excel file is linked to other files
-
- 2StarLounger
- Posts: 181
- Joined: 19 Feb 2016, 16:54
- Location: Veraval, India
-
- Administrator
- Posts: 78586
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Check if a excel file is linked to other files
No, that is not possible (except by checking each and every workbook for links to that workbook)
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 181
- Joined: 19 Feb 2016, 16:54
- Location: Veraval, India
Re: Check if a excel file is linked to other files
Okay, thank you :)