I use Microsoft Excel 2011 on a MacBook Pro.
I have a large workbook with hundreds of thousands of values & related formulas in a handful of tabs referencing each other. Working in manual mode is very helpful. When I hit 'recalculating', it usually takes a few seconds, but not a very long time by any mean.
It all works fine except when doing some basic copying and pasting operations (more precisely the latter). Excel often goes in a loooong loop (several minutes) with the dreaded colorful spinning disk being displayed. It even happens when I copy a single cell which only contains a text string to an empty cell in another tab. I suspect it recalculates the entire workbook, each and every cell, but I am not certain.
I found a thread suggesting to disable the recalculation before saving option, which I did. This seems to work much better, but then I quit Excel, re-opened it (option is still disabled) and I have the issue again. I actually had a similar behavior with other heavy-duty spreadsheets, works fine for a while, then the dreaded spinning disk appears again...
Anybody having a clue about how to avoid this very frustrating delay when pasting?
I have a large workbook with hundreds of thousands of values & related formulas in a handful of tabs referencing each other. Working in manual mode is very helpful. When I hit 'recalculating', it usually takes a few seconds, but not a very long time by any mean.
It all works fine except when doing some basic copying and pasting operations (more precisely the latter). Excel often goes in a loooong loop (several minutes) with the dreaded colorful spinning disk being displayed. It even happens when I copy a single cell which only contains a text string to an empty cell in another tab. I suspect it recalculates the entire workbook, each and every cell, but I am not certain.
I found a thread suggesting to disable the recalculation before saving option, which I did. This seems to work much better, but then I quit Excel, re-opened it (option is still disabled) and I have the issue again. I actually had a similar behavior with other heavy-duty spreadsheets, works fine for a while, then the dreaded spinning disk appears again...
Anybody having a clue about how to avoid this very frustrating delay when pasting?
