Get Data from SharePoint Folder in Excel missing some files

Question

Hi, 

I'm trying to create a query in Excel to return specific files from a SharePoint Site. My approach is to use the Get Data -> From File -> From Sharepoint Folder option. I would then filter from the full list of documents on the site.

Most files are returned however some are missing (the list is incomplete), specifically some that I have recently uploaded to the sharepoint site and can see are present in the browser. I have tried to upload a single Excel file to multiple locations in the document library but in all cases it is not returned in the original query. 

I have tested this process on another sharepoint site and it looks to work without problem. 

I thought there could be a delay in refreshing the sharepoint site before files are available to query but it has been at least 2 days since I uploaded. 

Is there any process to make files available to query in Excel?

Thank you for any help. 

David

Answer 1

Hi David,

If the issue persists, feel free to post back with the requested information.

Regards,

Tina