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 said:
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
:
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"
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?
