How to speed up Mathcad Prime for large data sets?

[Andy_C]

Does anyone know how to speed up MCP for processing large data sets?

I am working with a 50832x14 size data set that is output in Excel from another program. I would prefer to filter, sort, and manipulate the data in MCP vs Excel. However, trying to execute a simple filter step in MCP on a data set this large has proven impossible. I can't get the function to complete (endless spinning wheel). Whereas I can complete this one step in Excel in about 1sec.

Does anyone know how to speed this up? Or any other tricks for processing large data sets in MCP? I would really, really prefer to avoid Excel but at this point I have to use it.

Thanks!

[VladimirN]

Crosspost: https://community.ptc.com/t5/Mathcad/How-to-speed-up-Mathcad-Prime-for-large-data-sets/m-p/858363#M205315

[Andy_C · Accepted solution]

Hi VladimirN, thanks for responding. Werner_E provided a solution!

Mathcad Prime 8.0, Excel via Windows 10 Pro.