Thanks for your reply.

I got it in Normal view and Auto calculation is not checked. I tried to
unhide these rows from code and from design and it takes around 3 mins
but when hidding them it takes 2 secs. I tried a last week version and
it is fast. I also downloaded Excel WB rebuilder and that didn't fix
the issue.