Sub Totals option greyed out

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
 
S

Sheeloo

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

Subtotal function is greyed-out - can't insert 3
filter result- total row numbers varies 1
How do I copy and paste only the sub-total from a list 3
MSOffice 2007 - Excel - Subtotal Function 0
how to get totals? 1
Can't subtotal data from query 0
Import external data into Excel 2007 so I can subtotal it 2
Hyperlink option is greyed out 4

Top