View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Subtotal function not available

Unprotect the sheet maybe?

Mike

"Graeme" wrote:

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