ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trouble sorting a subtotalled list (https://www.excelbanter.com/excel-discussion-misc-queries/222294-trouble-sorting-subtotalled-list.html)

Coach Ron

Trouble sorting a subtotalled list
 
When I try and sort a subtotalled list from largest to smallest by clicking
the Z to A button I get the message "This removes the subtotals and sorts
again. If you want to sort the sutotalled groups, choosev the Cancel button
then collapse the outline and try again."

How do I do this/ Why does this work sometimes but not always?


All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com