Hi,

This could happen if there are some objects/data at the end of the sheet
(last row). Check and remove the object/data and then re-try. It would also
help, if you could post the spreadsheet.

"SouthEastEssex" wrote:

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.