View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Subtotal function is greyed-out - can't insert

By chance, is your workbook a 'shared workbook'?
Tools Shared Workbook Uncheck the little box OK

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"jmcclain" wrote:

I am trying to insert subtotals into a spreadsheet. I have made sure there
are no blank dells or columns, but the "subtotal" option is still greyed out.

Can anyone assist?

Using Excel 2003.

Thanks

Jon