VBA Copy from Closed Workbook

[MikoSDS]

Hello Everyone,

I have a small problem with copying sheets from closed workbook "x" to my workbook "y". So the copying isn't the problem, just the formulas in workbook "x" because in this workbook I have formulash which referres to another sheet in this workbook. So when I am coping this sheet and with Application.Screenupdating = False, the formulas returns #VALUE , but if I do the same thing just with Application.Screenupdating = True it works perfeclly. Seems like the screenupdating is causing the problem, is there any way to do this with Application.Screenupdating = False and the formulas will return correct numbers?

Thank you in advance!

 

[MikoSDS]

My fault, the problem was caused by Calculation Manual, should be automatic, not the screenupdating.