Forum Discussion
Slow Performance; Slow to Open/Save
Hello, I have created a data model within a workbook comprised of 15+ Excel data sources and 1-2 from SharePoint. The Excel data source files range from 10k-100k rows, which are located on our ne...
Hi Michael Hang,
The refresh time is not unusual in my experience, are you using 32 Bit Excel?
I'd encourage you to vote for this idea in the Excel User Voice forum to speed up query refresh
In terms of the file opening and saving that does sound unusual. Do you have any formulas in your file?
Also how many slicers do you have and how many Pivot Tables are they connected to?