Excel keeps calculating - no idea why?

Originally Posted by bebo021999

Try to delete 90% of indirect function in that sheet (may be, from column F to end right columns) to see if it is faster.

This doesn't help.

I changed ALL the formulae in "Production" to fixed (i.e. not INDIRECT) formulae and then simply copied the sheet. There was no delay.

Doing the same exercise with the "Production" INDIRECT formula: the delay was significant as Excel recalculated.

So my conclusion is that the prime cause of the performance problems IS the use of INDIRECT.

Originally Posted by JohnTopley

I changed ALL the formulae in "Production" to fixed (i.e. not INDIRECT) formulae and then simply copied the sheet. There was no delay.

Doing the same exercise with the "Production" INDIRECT formula: the delay was significant as Excel recalculated.

So my conclusion is that the prime cause of the performance problems IS the use of INDIRECT.

Yes, you're right. If you remove ALL indirect it's solved (in the past I always removed most of the formula but never in ALL cells). The weird thing is that this function was already included in my previous file. So I must have changed something, will check again.
If you see the issue in it, please inform.

Thanks a lot, that's already one step further.