After setting up a subtotal worksheet any attempt at selecting either level 1
or 2 from the subtotal drop down levels produces the following error message
"Cannoot shift objects from sheet" and the selection fails to work.

What is this error message and how can I get the sub-total levels to run
correctly?

P.S. This worksheet is over 6,900 rows long with multiple formulae; it also
appears in two other worksheets in the same files which are in a different
sort sequence.