Can anyone advice on approaches to enumerating a given document library for any Excel files that have links? as a bonus, it would be great if I could also know what other files they link to.



By PowerShell, you could loop through all excel files and download the excel files in the document library. Then read the data in the excel file to check if there are links.

More references:

PowerShell: Download Documents/Files from SharePoint OnPrem.

Download All Files From a SharePoint Library Programmatically using PowerShell.

Integrating Microsoft Excel with PowerShell: Reading Data

PowerShell - Read an Excel file using COM Interface.

| improve this answer | |
  • Hi @Amy_MSFT, I don't want to download all the files as there could be potentially hundreds of thousands of Excel files. – Ushka Oct 11 '19 at 13:43
  • I am afraid that we cannot read the excel content if we do not download the excel files by PowerShell. – Amy_MSFT Oct 16 '19 at 2:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.