LW_Ambassador
New Member
- Joined
- Jun 11, 2023
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello,
First post, so please bear with me.
I am using Excel 365. I have built a document pulling data from SQL and OneDrive. I've used Power Query and Power Pivot. I would like to make sure the document is performing at its best in the least amount of time possible. Is there a way I can see the total time it takes to refresh all data? I would like to tweak and make comparisons.
I don't know if it matters, but I am working in a server environment so it is definitely slower than working in a document off the server so if anyone has any helpful suggestions there, that would be great!
Thank you!
LW_Ambassador
First post, so please bear with me.
I am using Excel 365. I have built a document pulling data from SQL and OneDrive. I've used Power Query and Power Pivot. I would like to make sure the document is performing at its best in the least amount of time possible. Is there a way I can see the total time it takes to refresh all data? I would like to tweak and make comparisons.
I don't know if it matters, but I am working in a server environment so it is definitely slower than working in a document off the server so if anyone has any helpful suggestions there, that would be great!
Thank you!
LW_Ambassador