#CALC! error when using macro to copy&paste values

I figured out why this error is happening, so I will focus on that.
I made a manufacture sheet that gets outcome from a product name.
And when my macro is launching, it continuously change the product name, and copy values from manufacture sheet and paste to another sheet.
During this procedure, I found eve online add-in cannot calculate values during macro is launching. I used Application.CalculateFull to force calculate, and also manually made a delay to wait for calculation, but however long I delayed, it doesn’t calculate.
So, I want a solution about this.
Thank you for reading.

So, I think when macro changes product name, other cells are #BUSY!, and macro copy and paste #busy-related value so it produces #CALC! error.
I checked it by launching a macro line-by-line