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