Good question. Not sure why. I suppose that Excel can fairly quickly
sort through the empty cells when not shared. But when it is shared, I
guess it makes all sort of comparaison for each cell.
The smaller selection makes the macro run faster when not shared too,
but the huge difference is when it is shared.


Jim Rech a écrit :

But what does the workbook being shared have to do with this? I said the
problem occurs only when shared.