Using subtotal function in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2294086%22%20slang%3D%22en-US%22%3EUsing%20subtotal%20function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2294086%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20try%20to%20subtotal%2C%20I%20get%20this%20error%20(see%20my%20snip%20below).%26nbsp%3B%20I%20have%20been%20using%20subtotals%20for%20over%20a%20decade%20and%20now%20this%20ridiculous%20warning%2C%20any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20course%20I%20can%20copy%20all%20my%20data%20to%20a%20new%20spreadsheet%20and%20the%20error%20goes%20away%20but%20I%20am%20tired%20of%20doing%20this%20constantly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22target_21_0-1619461568955.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275628iA9CFBCD57F44A10A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22target_21_0-1619461568955.png%22%20alt%3D%22target_21_0-1619461568955.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2294086%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2294124%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20subtotal%20function%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2294124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1037200%22%20target%3D%22_blank%22%3E%40target_21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20selecting%20all%20rows%20below%20the%20last%20row%20of%20data.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Clear%20%26gt%3B%20Clear%20All.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

When I try to subtotal, I get this error (see my snip below).  I have been using subtotals for over a decade and now this ridiculous warning, any ideas?

 

Of course I can copy all my data to a new spreadsheet and the error goes away but I am tired of doing this constantly.

 

target_21_0-1619461568955.png

 

1 Reply

@target_21 

Try selecting all rows below the last row of data.

On the Home tab of the ribbon, click Clear > Clear All.