How to speed up Autofiltering?
Yes, It's a large file.
Why does Excel copies a cell so long from these files? The sandglass appears
for half a minute after I click Copy!
"Pete_UK" ???????/???????? ? ???????? ?????????:
ups.com...
Is this a large file with a lot of formulae? If so, you can fix the
values of the formulae so that Excel does not have to recalculate them
each time you select a different filter option.
Hope this helps.
Pete
|