Excel Subtotal disabled (grayed out)

October 31, 2011

I don’t use sub totaling in Excel… but someone here asked me to figure out the issue of his sub total feature being “grayed out” in Excel 2007 or 2010. I opened the file in Excel 2003 and sub totaling worked. The file he was working with is a file I created with a Microsoft Query enabled to refresh on open in the background. He runs that file and copies the data out and into another file so he can edit it. I did some research and found that the queried data is still in some kind of list or range. On the ‘Design’ tab, you’ll find a ‘Convert to Range’ feature. Click that and you should be ok.