How to make Excel xlsm file run faster / smoother

%3CLINGO-SUB%20id%3D%22lingo-sub-1987819%22%20slang%3D%22en-US%22%3EHow%20to%20make%20Excel%20xlsm%20file%20run%20faster%20%2F%20smoother%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1987819%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20importing%20my%20source%20files%20into%20Power%20Query%2C%20then%20eventually%20exporting%20and%20loading%20the%20final%20query%20that%20I%20am%20working%20on%20into%20an%20excel%20worksheet%20(sheet%203)%2C%2049%20Columns%20x%203150%20rows%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EOn%20top%20of%20that%2C%20I%20do%20have%204%20macros%20on%202%20other%20sheets%20(sheet%201%20and%202).%20Scatter%20charts%20on%20Sheet%201%20and%202%20that%20reference%20the%20final%20query%20that%20I've%20exported%20as%20a%20table%20on%20sheet%203.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20size%20is%201.67%20mb%20and%20gets%20lags%20whenever%20I%20want%20to%20save%20it.%20Every%20time%20I%20click%20onto%20a%20slicer%20it%20goes%20into%20the%20%22file%20name%20(not%20responding)%22%20mode%20for%20a%20while%20(approximately%2010s)%2C%20before%20eventually%20loading%20up.%20I%20understand%20that%20it%20is%20not%20considered%20too%20large%20to%20run%20but%20it%20is%20causing%20significant%20inconvenience.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20make%20the%20file%20run%20smoother%3F%20Can%20I%20not%20load%20the%20query%20into%20a%20table%20onto%20sheet%203%20but%20still%20get%20the%20scatter%20plot%20to%20work%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1987819%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1988878%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20make%20Excel%20xlsm%20file%20run%20faster%20%2F%20smoother%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1988878%22%20slang%3D%22en-US%22%3EThis%20community%20is%20for%20things%20related%20to%20Microsoft%20Learn%20and%20Microsoft%20Certifications.%20I%20would%20recommend%20reaching%20out%20on%20the%20Microsoft%20Excel%20Community%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1988908%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20make%20Excel%20xlsm%20file%20run%20faster%20%2F%20smoother%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1988908%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885269%22%20target%3D%22_blank%22%3E%40zyc93%3C%2FA%3E%26nbsp%3BTry%20your%20question%20in%20the%20Excel%20forum%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3EThe%20Microsoft%20Excel%20Community%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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? 

4 Replies
This community is for things related to Microsoft Learn and Microsoft Certifications. I would recommend reaching out on the Microsoft Excel Community https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat

@zyc93 Try your question in the Excel forum: The Microsoft Excel Community

Hi @Julian Sharp, so sorry that is my mistake. Will do that! 

@rhancock Thanks for pointing out my mistake. Will try there instead.