Forum Discussion
Excel Query connecting to a SharePoint file error
I have multiple Excel spreadsheets connected to a Main spreadsheet via Query. All of the files are saved in SharePoint but we use the native app to edit them given they have Macros and VBA functions....
I'd start with the source. Are you able to open the workbook directly through SharePoint?
Yes, all of the connected files are working on their own That's why I'm confused why the query can't pull up the data within them which was working previously.