I am working with an Excel file containing 1,000 records and need to create a Pivot Table using Modern Excel Activities. However, the process is taking too long to execute.
Someone suggested enabling “Read Format” as “Raw Values” and keeping Excel open, but I tried this, and it didn’t improve performance.
Has anyone encountered a similar issue or found a more efficient solution?
If there is more data in the excel, these activities will take more time. So we suggest to use the VB Macros. There is one activity to execute macros called Invoke VBA.
If you are proficient in writing macros, that’s great; if not, feel free to seek assistance from an LLM.
Check the below documentation to know about Invoke VBA activity,
