Copy Range: Exception from HRESULT: 0x800AC472

Getting “Copy Range: Exception from HRESULT: 0x800AC472” for what think is a simple copy-paste into another tab. The error only happens when I remove formulas. I do not get the error when I select all.

I tried to replicate the error, but no success. Can you send the input workbook, or a dummy version of it with same formulas?

I did a work around with creating a data table, will delete. Thanks though

Hi, I am facing the same issue. Can you please elobrate your work around.