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

How do I copy and paste only the sub-total from a list 3
Subtotal function is greyed-out - can't insert 3
how to get totals? 1
Pivot Table Sub total and totals 4
Sub-Totals Question 1
Excel formula for adding up sub-totals in time format 2
Import external data into Excel 2007 so I can subtotal it 2
Spreadsheet summary automatically referrences totals of worksheets 2

Top