Sub-total feature is unavailable in Office 2003 Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the sub-total feature in Excel 2003. I have used it in
previous versions of excel, but in 2003 it is on the menu, but not available
for use.
 
No. The sheet is not protected. Thanks in advance for any help you can give.
 
Yes. I have discovered that if I use AutoFilter, the subtotals do not work.
If I take AutoFilter off, the subtotals will work if I copy the information
into a different sheet and then type new headings to the columns of
information. It seems to work sporadically. Thanks!
 
That's the reason, it has built in totals (Toggle Total Row) on the list
toolbar and you cannot apply data>subtotal on either filtered or a list
created with this new function. You can convert it as follows

right click in the list and select List > Convert to Range
 
You must log in or register to reply here.

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

Sub Totals option greyed out 1
Excel How to enable engineering functions in MS Excel 2000? 3
How to copy a spreadsheet in shared workbook 3
Totalling Dynamic Range Subtotals in Excel 2003 6
Excel 2007 / right-click / pick from drop down list 1
function wizard on office 2003 1
CONVERT function for Excel 2003 2
Lose the 0 in the Total cell 6

Back
Top