I am using Power Automate Desktop to create a flow that copies and pastes the entire data area on the sheet from A to B, from B to C, and from C to a temporary Excel file (work Excel file) that opens for work, while opening Excel files (assumed to be A/B/C) with about 300,000 rows and 70 columns in read-only mode in order. Then, I perform some processing such as value copying between columns and save it in CSV format.
A is the original data, and B and C each have formulas entered in about 10 columns on the right end.
Therefore, every time I copy and paste, I perform a recalculation with F9 by “Send Key”, but here I set enough Wait until the processing is finished and I can confirm that the processing is finished.
Every time I copy and paste from A to B, from B to C, and from C to the work Excel file, I close the Excel file that became unnecessary in order, end the process, and clear the list.
The problem is that for some reason, after copying and pasting from C to the work Excel file, the process of closing C becomes “No response”.
Since the same file as A/B/C with about 10 rows of test data ends without any problem, I suspect a memory problem, but I do not know the cause because it ends without any problem when I perform almost the same process with the flow of A→B→work Excel file→CSV (the pattern without C).
The environment is Windows 10, Office 365, Power Automate Desktop is all up to date, and Power Automate Desktop is running as an administrator.
The Excel files are on Share Point Online, and I sync locally with the upper folder where the files are stored, and open each file by getting the path from Explorer on Power Automate Desktop.
There is no similar case on the web, and I am stuck and desperate.
I would appreciate any advice. Thank you very much.
