March 25, 2011

Excel takes long time to delete rows


Problem: It takes long time for calculating

Tools - Options -
check Manual
instead of Automatic,
user reports that after this option, excel deletes rows immediately,
and only when saving document, excel calculates for long time, however much less time than before.

No comments: