|
Subtotals in Excel 2003 for doc exported from Sharepoint list
Am I going crazy? I just got XP today with Excel 2003. I know everything
looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? |
Is the worksheet protected?
Have you grouped multiple worksheets? And make a note of this--just in case you notice something different with your subtotals: http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Holly OK wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson |
Permission says "unrestricted access"
No, there are not grouped worksheets. The only thing I can think of is that I exported it from a list I created in Sharepoint. But, I "unlinked" the spreadsheet from Sharepoint. The link you gave me does not seem to apply, because it is not like subtotals are acting weird...instead it just won't let me use the functionality at all. Does this better explain anything? "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple worksheets? And make a note of this--just in case you notice something different with your subtotals: http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Holly OK wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson |
The sheet is protected? Unprotect it.
The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? |
The link was for future use.
I don't use sharepoint, but Gord asked if the workbook was shared. Is it? Holly OK wrote: Permission says "unrestricted access" No, there are not grouped worksheets. The only thing I can think of is that I exported it from a list I created in Sharepoint. But, I "unlinked" the spreadsheet from Sharepoint. The link you gave me does not seem to apply, because it is not like subtotals are acting weird...instead it just won't let me use the functionality at all. Does this better explain anything? "Dave Peterson" wrote: Is the worksheet protected? Have you grouped multiple worksheets? And make a note of this--just in case you notice something different with your subtotals: http://support.microsoft.com/default...b;en-us;831824 Multilevel subtotals are in the wrong position in Excel 2002 and Excel 2003 Holly OK wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson -- Dave Peterson |
By the way, I exported it and saved it to my own computer. I remember
clicking "unlink" somewhere but don't remember where that was. So, I'm not working on a document that is sitting in a shared environment. Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? |
Gord,
How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? |
Check the title bar.
If you see "[Shared]" following the workbook name, then it's a shared workbook. If you see "[Group]" in the title bar, take a look at the worksheet tabs. You'll see at least two that are selected. Rightclick on any worksheet tab and select Ungroup Sheets. Where did you check permissions? And if none of this works, can you get subtotals to work on a brand new worksheet in a brand new workbook? If no, then maybe it's the toolbar that's screwed up. Only if you couldn't get that test worksheet/workbook to do subtotals: Tools|Customize|Toolbars Tab select worksheet menu bar and hit reset This will remove any customizations to that toolbar, though. (you can rebuild them later at your leisure.) Holly OK wrote: Gord, How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson |
Dave,
The title of the document in the blue bar at the very top of the screen has the Excel logo, then says Microsoft Excel has a dash, then the filename.xls. Nothing more in the title bar until you get to the window minimize/resize/close buttons. so I don't think it is shared. It is not grouped because there is not another worksheet in the document. I checked permissions under the "File" menu, the menue item that says "Permission" is selected and from there there is an orange box with a checkmark by "unrestricted access". But I just found protection under the toolbar. I can't figure out how to deselect the options that are checked and I don't know how they got checked. Is it something to do with the process in exporting it from a sharepoint list? The options checked are as follows: Under protect sheet the "protect worksheet and contents of locked cells is checked. This is true whether it is a newly created workbook or the original one I exported. Under "allow users of worksheet to" box the only two things checked are "select locked cells and select unlocked cells. I don't know the password since I didn't do this, I tried my password from my network login and unchecked the protect worksheet box at the top and it didn't let me check "ok" just cancel. I tried creating a new workbook, file name is "book5" with no indication of sharing in the title. The protection attempts reacted a little different. I selected unprotect sheet and typed in my current network password (not knowing what else to try), it let me hit ok in this case. But, it still did not give me the ability to select the subtotal feature. I also tried to reset the toolbar as follows: Rightclicked the toolbar, hit the customize button, selected toolbar tab, the "worksheet menue bar" was already checked. I clicked on it to highlight. Then hit "reset" and ok on the dialog box that popped up. Then I closed the customize window. Went to the Data menu, and subtotal was still grey. The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? Do I need to move these questions to a forum for Sharepoint? do you think it is an Excel issue or a sharepoint issue? Holly "Dave Peterson" wrote: Check the title bar. If you see "[Shared]" following the workbook name, then it's a shared workbook. If you see "[Group]" in the title bar, take a look at the worksheet tabs. You'll see at least two that are selected. Rightclick on any worksheet tab and select Ungroup Sheets. Where did you check permissions? And if none of this works, can you get subtotals to work on a brand new worksheet in a brand new workbook? If no, then maybe it's the toolbar that's screwed up. Only if you couldn't get that test worksheet/workbook to do subtotals: Tools|Customize|Toolbars Tab select worksheet menu bar and hit reset This will remove any customizations to that toolbar, though. (you can rebuild them later at your leisure.) Holly OK wrote: Gord, How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson |
With that worksheet active, when you click:
Tools|Protection| do you see "protect sheet" or "unprotect sheet" as an option. If you see "protect sheet", then that worksheet is not protected. But I don't think that this is the problem. When you wrote this: The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? It gives the answer away. xl2003 added Data|List. That's the thing that gives the asterisk in that cell. You have a couple of options. 1. You can remove that list and make it back to a simple range. Select the complete list/range and then Data|List|Convert to Range 2. Or you can use the list (which may be a good thing to learn for both of us <I just upgraded to xl2003, too!) Then Data|List|Total Row Then click on of those cells in the total row and you'll see what type (count, sum, average) of function you can use for that cell. Just as a note, notice that the =subtotal() changed in xl2003. The old =subtotal() function would ignore values in rows hidden by an autofilter. The new =subtotal() has parameters that you can use to ignore both rows hidden by an autofilter and hidden manually. === Long way home, but I think we've found it! Holly OK wrote: Dave, The title of the document in the blue bar at the very top of the screen has the Excel logo, then says Microsoft Excel has a dash, then the filename.xls. Nothing more in the title bar until you get to the window minimize/resize/close buttons. so I don't think it is shared. It is not grouped because there is not another worksheet in the document. I checked permissions under the "File" menu, the menue item that says "Permission" is selected and from there there is an orange box with a checkmark by "unrestricted access". But I just found protection under the toolbar. I can't figure out how to deselect the options that are checked and I don't know how they got checked. Is it something to do with the process in exporting it from a sharepoint list? The options checked are as follows: Under protect sheet the "protect worksheet and contents of locked cells is checked. This is true whether it is a newly created workbook or the original one I exported. Under "allow users of worksheet to" box the only two things checked are "select locked cells and select unlocked cells. I don't know the password since I didn't do this, I tried my password from my network login and unchecked the protect worksheet box at the top and it didn't let me check "ok" just cancel. I tried creating a new workbook, file name is "book5" with no indication of sharing in the title. The protection attempts reacted a little different. I selected unprotect sheet and typed in my current network password (not knowing what else to try), it let me hit ok in this case. But, it still did not give me the ability to select the subtotal feature. I also tried to reset the toolbar as follows: Rightclicked the toolbar, hit the customize button, selected toolbar tab, the "worksheet menue bar" was already checked. I clicked on it to highlight. Then hit "reset" and ok on the dialog box that popped up. Then I closed the customize window. Went to the Data menu, and subtotal was still grey. The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? Do I need to move these questions to a forum for Sharepoint? do you think it is an Excel issue or a sharepoint issue? Holly "Dave Peterson" wrote: Check the title bar. If you see "[Shared]" following the workbook name, then it's a shared workbook. If you see "[Group]" in the title bar, take a look at the worksheet tabs. You'll see at least two that are selected. Rightclick on any worksheet tab and select Ungroup Sheets. Where did you check permissions? And if none of this works, can you get subtotals to work on a brand new worksheet in a brand new workbook? If no, then maybe it's the toolbar that's screwed up. Only if you couldn't get that test worksheet/workbook to do subtotals: Tools|Customize|Toolbars Tab select worksheet menu bar and hit reset This will remove any customizations to that toolbar, though. (you can rebuild them later at your leisure.) Holly OK wrote: Gord, How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson -- Dave Peterson |
Yes! I had to make it a range. I'm wondering what the "list" even is? Maybe
so I can import it back to sharepoint? Now I'm having a problem with the countif function. It is just showing up as text instead of giving me the results... Ugh, I didn't realize Excel 2003 would be so different. I'm hoping I'm just getting off to a bad start. Thanks for your help, I'm going to search through the forum to see if I can find anything on my next problem. Holly "Dave Peterson" wrote: With that worksheet active, when you click: Tools|Protection| do you see "protect sheet" or "unprotect sheet" as an option. If you see "protect sheet", then that worksheet is not protected. But I don't think that this is the problem. When you wrote this: The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? It gives the answer away. xl2003 added Data|List. That's the thing that gives the asterisk in that cell. You have a couple of options. 1. You can remove that list and make it back to a simple range. Select the complete list/range and then Data|List|Convert to Range 2. Or you can use the list (which may be a good thing to learn for both of us <I just upgraded to xl2003, too!) Then Data|List|Total Row Then click on of those cells in the total row and you'll see what type (count, sum, average) of function you can use for that cell. Just as a note, notice that the =subtotal() changed in xl2003. The old =subtotal() function would ignore values in rows hidden by an autofilter. The new =subtotal() has parameters that you can use to ignore both rows hidden by an autofilter and hidden manually. === Long way home, but I think we've found it! Holly OK wrote: Dave, The title of the document in the blue bar at the very top of the screen has the Excel logo, then says Microsoft Excel has a dash, then the filename.xls. Nothing more in the title bar until you get to the window minimize/resize/close buttons. so I don't think it is shared. It is not grouped because there is not another worksheet in the document. I checked permissions under the "File" menu, the menue item that says "Permission" is selected and from there there is an orange box with a checkmark by "unrestricted access". But I just found protection under the toolbar. I can't figure out how to deselect the options that are checked and I don't know how they got checked. Is it something to do with the process in exporting it from a sharepoint list? The options checked are as follows: Under protect sheet the "protect worksheet and contents of locked cells is checked. This is true whether it is a newly created workbook or the original one I exported. Under "allow users of worksheet to" box the only two things checked are "select locked cells and select unlocked cells. I don't know the password since I didn't do this, I tried my password from my network login and unchecked the protect worksheet box at the top and it didn't let me check "ok" just cancel. I tried creating a new workbook, file name is "book5" with no indication of sharing in the title. The protection attempts reacted a little different. I selected unprotect sheet and typed in my current network password (not knowing what else to try), it let me hit ok in this case. But, it still did not give me the ability to select the subtotal feature. I also tried to reset the toolbar as follows: Rightclicked the toolbar, hit the customize button, selected toolbar tab, the "worksheet menue bar" was already checked. I clicked on it to highlight. Then hit "reset" and ok on the dialog box that popped up. Then I closed the customize window. Went to the Data menu, and subtotal was still grey. The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? Do I need to move these questions to a forum for Sharepoint? do you think it is an Excel issue or a sharepoint issue? Holly "Dave Peterson" wrote: Check the title bar. If you see "[Shared]" following the workbook name, then it's a shared workbook. If you see "[Group]" in the title bar, take a look at the worksheet tabs. You'll see at least two that are selected. Rightclick on any worksheet tab and select Ungroup Sheets. Where did you check permissions? And if none of this works, can you get subtotals to work on a brand new worksheet in a brand new workbook? If no, then maybe it's the toolbar that's screwed up. Only if you couldn't get that test worksheet/workbook to do subtotals: Tools|Customize|Toolbars Tab select worksheet menu bar and hit reset This will remove any customizations to that toolbar, though. (you can rebuild them later at your leisure.) Holly OK wrote: Gord, How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson -- Dave Peterson |
OK, I figured out my problem with count if. I didn't have quotes around the
criteria. Not Excel's fault. :-) "Holly OK" wrote: Yes! I had to make it a range. I'm wondering what the "list" even is? Maybe so I can import it back to sharepoint? Now I'm having a problem with the countif function. It is just showing up as text instead of giving me the results... Ugh, I didn't realize Excel 2003 would be so different. I'm hoping I'm just getting off to a bad start. Thanks for your help, I'm going to search through the forum to see if I can find anything on my next problem. Holly "Dave Peterson" wrote: With that worksheet active, when you click: Tools|Protection| do you see "protect sheet" or "unprotect sheet" as an option. If you see "protect sheet", then that worksheet is not protected. But I don't think that this is the problem. When you wrote this: The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? It gives the answer away. xl2003 added Data|List. That's the thing that gives the asterisk in that cell. You have a couple of options. 1. You can remove that list and make it back to a simple range. Select the complete list/range and then Data|List|Convert to Range 2. Or you can use the list (which may be a good thing to learn for both of us <I just upgraded to xl2003, too!) Then Data|List|Total Row Then click on of those cells in the total row and you'll see what type (count, sum, average) of function you can use for that cell. Just as a note, notice that the =subtotal() changed in xl2003. The old =subtotal() function would ignore values in rows hidden by an autofilter. The new =subtotal() has parameters that you can use to ignore both rows hidden by an autofilter and hidden manually. === Long way home, but I think we've found it! Holly OK wrote: Dave, The title of the document in the blue bar at the very top of the screen has the Excel logo, then says Microsoft Excel has a dash, then the filename.xls. Nothing more in the title bar until you get to the window minimize/resize/close buttons. so I don't think it is shared. It is not grouped because there is not another worksheet in the document. I checked permissions under the "File" menu, the menue item that says "Permission" is selected and from there there is an orange box with a checkmark by "unrestricted access". But I just found protection under the toolbar. I can't figure out how to deselect the options that are checked and I don't know how they got checked. Is it something to do with the process in exporting it from a sharepoint list? The options checked are as follows: Under protect sheet the "protect worksheet and contents of locked cells is checked. This is true whether it is a newly created workbook or the original one I exported. Under "allow users of worksheet to" box the only two things checked are "select locked cells and select unlocked cells. I don't know the password since I didn't do this, I tried my password from my network login and unchecked the protect worksheet box at the top and it didn't let me check "ok" just cancel. I tried creating a new workbook, file name is "book5" with no indication of sharing in the title. The protection attempts reacted a little different. I selected unprotect sheet and typed in my current network password (not knowing what else to try), it let me hit ok in this case. But, it still did not give me the ability to select the subtotal feature. I also tried to reset the toolbar as follows: Rightclicked the toolbar, hit the customize button, selected toolbar tab, the "worksheet menue bar" was already checked. I clicked on it to highlight. Then hit "reset" and ok on the dialog box that popped up. Then I closed the customize window. Went to the Data menu, and subtotal was still grey. The only thing that looks kind of strange, and maybe this is new to this Excel version...I've never noticed the blue asterik in column A in the row under my last row of data. Is this any indication of something strange? Do I need to move these questions to a forum for Sharepoint? do you think it is an Excel issue or a sharepoint issue? Holly "Dave Peterson" wrote: Check the title bar. If you see "[Shared]" following the workbook name, then it's a shared workbook. If you see "[Group]" in the title bar, take a look at the worksheet tabs. You'll see at least two that are selected. Rightclick on any worksheet tab and select Ungroup Sheets. Where did you check permissions? And if none of this works, can you get subtotals to work on a brand new worksheet in a brand new workbook? If no, then maybe it's the toolbar that's screwed up. Only if you couldn't get that test worksheet/workbook to do subtotals: Tools|Customize|Toolbars Tab select worksheet menu bar and hit reset This will remove any customizations to that toolbar, though. (you can rebuild them later at your leisure.) Holly OK wrote: Gord, How do I tell if it is shared? How do I tell if it is grouped? I don't think so. I already checked "permissions" and it is unrestricted...is that what you mean by is it protected? Holly "Gord Dibben" wrote: The sheet is protected? Unprotect it. The sheet is shared? Unshare it. Two or more sheets are grouped together? Ungroup them. Gord Dibben Excel MVP On Tue, 1 Mar 2005 12:39:02 -0800, "Holly OK" wrote: Am I going crazy? I just got XP today with Excel 2003. I know everything looks a little disorienting. But, I've got a basic spreadsheet, I'm trying to apply subtotals and the option is greyed out as is outlining. Is there a problem I don't know about. Any ideas why? -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 12:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com