[mso] Re: Excel - Adding pages and dealing with Pivot tables

Okay...I believe I understand and that DOES help a lot, Linda! Thanks!!

The biggest problem I was having was being TOLD to use this master page as a
template, yet realizing that templates are NOT used by removing the current
into and adding new!

So now, by right clicking and adding a new page with that week's date...and
THEN changing the pivot table to calc the data from the NEXT sheet...I
believe I should now be getting some correct results as well as some much
missed understanding of this all!

I think the biggest part of my brain fighting this was cos' it not only
didn't make sense to me...but the process I was told to use didn't make
sense as the way it SHOULD work. And now...thanks to you...I see that it
wasn't me...it was the process I was told to us.

I LOVE it when the light finally goes off! ;-) Thanks, chick!

--------------------------------------------
Dian D. Chapman
US Microdyne
2275 Half Day Road
Suite 350
Bannockburn, IL  60015
E-Mail:          DChapman@xxxxxxxxxxxxxxx
Toll-Free:       800-828-3859
Phone:           847-244-4800
Fax:             847-244-4801
-------------------------------------------


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Linda F. Johnson
Sent: November 11, 2003 17:40
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel - Adding pages and dealing with Pivot tables


Go to the sheet where the pivot table is located...right click on the pivot
table and choose Pivot Table wizard....this will bring you to the last step
(3) of the wizard...click the Back button to get to step two...here's where
it is showing which date is included in the pivot table and you will see the
data with "marching ants" around it...just click on the sheet where the data
you want included is and drag to select that data instead.

Pivot tables are a big chunk to be biting off before you really understand
excel, Dian....so try this and see if it gives you what you
want...otherwise, you are going to have to learn how to make pivot tables
and then you can create one for each sheet that you need one for.

Here's some down and dirty pivot table instructions:
 http://edferrero.m6.net/Pivot.html


Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Dian Chapman
Sent: Tuesday, November 11, 2003 5:38 PM
To: Mso
Subject: [mso] Excel - Adding pages and dealing with Pivot tables

Hey gang...

Back asking my @#$%! Excel Qs!<g>

You might remember last week or so I was asking about how to take a master
page that's had some formulas entered and copying it so the next week (yes,
the return of the timesheet!<g>) is added into and renamed for that week.

However, I just realized that there's a pivot table that calculates the
totals, etc, from the spreadsheet. If I have several spreadsheets...but need
to have the pivot table calc on just one within the group...is there someway
that I would need to specify WHICH sheet I want included in this PT's calcs?

Or is this something that would be specific to how the PT's been setup? I
really don't understand PTs yet...so not sure if this would make the results
times 2...if I had two sheets in there.

TIA...

--------------------------------------------
Dian D. Chapman
US Microdyne
2275 Half Day Road
Suite 350
Bannockburn, IL  60015
E-Mail:          DChapman@xxxxxxxxxxxxxxx
Toll-Free:       800-828-3859
Phone:           847-244-4800
Fax:             847-244-4801
-------------------------------------------


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: