If there is a blue border that appears around your data, then you have probably created a data list, and the Subtotals option will no longer be available for that data. For instance, Excel 2003 allows you to create formal data lists, which are generally used for generating XML data. If the problem occurs only in a single workbook, then the problem is probably with the data itself. (How to do this has been covered in other issues of ExcelTips.) If it happens with all the workbooks (even a new one) there is probably a problem with Excel, and you should look at fixing it or reinstalling it. When things are disabled in a workbook there is usually some setup which prevents it in some way. When she displays the Data menu, the option is grayed out, and she cannot select it. Katherine, using Office 2003, reports that when she is working with a table of data in Excel, she can't choose the Subtotals option from the Data menu.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |