I need to remove the formulas (but keep the values) from a large amount of cells (>100,000). I am currently using the “Copy Range” activity from the Excel Processing activities with the “Value” box checked for the CopyItems Option. This works, but it takes an excessive amount of time (over 10 hrs on my machine). I have the “Save changes” box turned off in the Application Scope and the Window hidden. Are there any options available to improve the performance of this? If I go into Excel and issue the Copy/Paste Values command manually, it only takes 1 second.
Hi, welcome to the community!
Sometimes is easier to just do it the human way, automating excel itself:
Thanks. This will work for now. I prefer to not use the mouse options as they can easily be interrupted. If someone has a vb script available to do the same work, I would appreciate that.
with VBA even easier, can be something simple like this:
Sub Sample() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ws.UsedRange.Value = ws.UsedRange.Value End Sub