View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Graeme Graeme is offline
external usenet poster
 
Posts: 59
Default Subtotal function not available

I have a sheet that already has a subtotal function. I used the
Data/Subtotals command and thought myself very clever.

Now I wish to extensively modify the sheet and completely re-do the
subtotals. However the option is now 'greyed out' in the drop down menu and
unavailable.

Why? How can I enable it again?

TIA. Graeme