Sub Totals option greyed out

  • Thread starter Thread starter drob2528
  • Start date Start date
D

drob2528

I have imported data from an ODBC data source using querry in Excel 2007.

If I select a cell within the returned data the sub total option on the data
tab is greyed out and I cannot sub total the data.

If I select a blank cell outside of the returned data range the subtotal
option is available.

I have always been able to import the querry data and immediately apply sub
totals in Excel 2003
 
Can you send the file to me?

To get my id click on my name in the post and follow instructions...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert subtotal in a query database Excel 2007 3
How do I copy and paste only the sub-total from a list 3
Subtotal function is greyed-out - can't insert 3
SumIf AND 6
Sum after Filter, Count after Fliter 2
Sub total 1
calculate filetred cells only 4
Help! Totally Grey Sheet 2

Back
Top