Dec 14 2020 06:25 PM - edited Dec 14 2020 07:00 PM
I am currently importing my source files into Power Query, then eventually exporting and loading the final query that I am working on into an excel worksheet (sheet 3), 49 Columns x 3150 rows
On top of that, I do have 4 macros on 2 other sheets (sheet 1 and 2). Scatter charts on Sheet 1 and 2 that reference the final query that I've exported as a table on sheet 3.
The file size is 1.67 mb and gets lags whenever I want to save it. Every time I click onto a slicer it goes into the "file name (not responding)" mode for a while (approximately 10s), before eventually loading up. I understand that it is not considered too large to run but it is causing significant inconvenience.
How do I make the file run smoother? Can I not load the query into a table onto sheet 3 but still get the scatter plot to work?
Dec 15 2020 05:17 AM
Dec 15 2020 05:21 AM
@zyc93 Try your question in the Excel forum: The Microsoft Excel Community
Dec 15 2020 05:54 PM
Hi @Julian Sharp, so sorry that is my mistake. Will do that!
Dec 15 2020 06:07 PM
@rhancock Thanks for pointing out my mistake. Will try there instead.