Forum Discussion
Solved
Speed-up a query to retrieve Excel tables from sharepoint
Dear all, I have a query that the latest step takes about 6/7 min. to load. I was wonder if I could do it differently and speed-up the process: let Source = SharePoint.Files("sharepoint.......
If various sheets are not essential then you can try saving the file as a .csv - those are faster typically than Excel files.
jennratten
Super User
Super UserIf various sheets are not essential then you can try saving the file as a .csv - those are faster typically than Excel files.
jennrattenSuper User
Super UserHi PabloML Have you had a chance to take a look at this? Please consider clicking Accept as Solution if this answered your question. Thanks!