Excel Spreadsheet running slow

[Skeen]

Does anyone know how to speed up an excel file? I have a lot of data that is running with several formulas, but I don't feel it should be this slow. I have other documents with more info that doesn't run this slow...

 

[Skeen]

I defined it to A20000 for all the formulas and no difference of speed, and exported CSV to do the same things. I feel like I've tried everything, but it is slow to open, slow to add the data, and extremely slow when trying to filter out the data that I need.

 

[sandy666]

maybe try PowerQuery (Get&Transform) instead of formulas

 

[Skeen]

How would I go about doing that?

 

[sandy666]

https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query

https://support.office.com/en-us/ar...38c-9d29-c6d29cb8df6a?ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/ar...04f-a9fe-1a04d52f249b&ui=en-US&rs=en-US&ad=US

https://support.office.com/en-us/ar...04f-a9fe-1a04d52f249b&ui=en-US&rs=en-US&ad=US