whenever user make changes in planning sheet they have to push calculate tab multiple times (from 1 to 3 times) . We found issues with "Hide Empty Rows" in "View Display Options" and we disabled that too. Still users need to click multiple times.
Any pointers would be appreciated.
Dont press calculate multiple times. YOu are only going to stress the system, if it is already calculating, for no reason by keep sending large excel from client to server. Look at the server CPU and also take a look at server stack trace to see whether it is doing anything.