I have users who are working in very large workbooks. The books take forever to recalculate due to a large number of offset formulas. To help speed things up I have included and auto-open macro that turns automatic calculation off. The users are happy with this solution. The problem is this - When they open excel to work in other unrelated workbooks the manual calculation remains.
What is the best way to handle this? Should I just turn auto-calc on when they close one of the large books? What if they have many of the large books open and only close one of them? Can excel turn manual calculation on for individual books (i.e. only the aforementioned large ones) but have all other books remain in auto calculation?
____________________
Mike
What is the best way to handle this? Should I just turn auto-calc on when they close one of the large books? What if they have many of the large books open and only close one of them? Can excel turn manual calculation on for individual books (i.e. only the aforementioned large ones) but have all other books remain in auto calculation?
____________________
Mike