loop through pivottables columns and rows
I have a pivot table that have 2 columns that I need to loop through
and read both columns and each items of each columns...the pivotitems
only allow reading one column...does anyone know how to
programmatically read both columns?
You can loop through the column fields and their items:
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
Set pt = ActiveSheet.PivotTables(1)
For Each pf In pt.ColumnFields
For Each pi In pf.PivotItems
Debug.Print pf.Name & " - " & pi.Name
> I have a pivot ta...New with Outlook 2003 and IMAP
We have just been directed that we have to start using Outlook 2003.
When I mark an email for trash or junk, I get a line through the topic
and it gets grayed out.
Is there a setting I can use that will put the email into trash or
junk when I identify it as trash or junk?
I am also trying to put my address book together. I need to find a way
to have any email coming in with the same address (ex:
(email@example.com) be made into a rule and make
sure it goes to the appropriate folder.
I am setup using an IMAP configuration.
Any help would b...Worksheet Changes
Have a worksheet that has data in the range A5:I105, would like cell
a2 to show a date that any of this data has changed, was thinking of
using a worksheet change_Event to manage this but not sure of how to
go about setting this up, have used the simple change event for a
single selection i.e A1 or B4 but not with a range area.
Any help would be Great
A bit more explanation along with layout and what desired output looks like.
Microsoft MVP Excel
"Steve" <firstname.lastname@example.org> wrote in mes...Pivottable Row SubTotals
I have just started using pivot tables, and have created one with sub
totals at the end of each row.
Is there a way of getting the totals to be at the begining of each
Thanks in advance.
That isn't an option provided by pivot tables.
Matthew <email@example.com> wrote in message
> I have just started using pivot tables, and have created one with sub
> totals at the end of each row.
> Is there a way of getting the totals to be at the begining of each
> Thanks in ad...New Office reminds me of New Coke
Everyone hates it.
The difference is that at least with Coke, there was Pepsi.
Please admit that his was a failure and provide a patch that allows the
world to toggle back to Classic Office.
Stop being so arrogant. Did you really think we were going to pay billions
to re-train everyone in a flippin' recession?
It doesn't make you bad or dumb to admit you made a mistake. It means that
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this su...New CRM MVP's
I'd like to welcome our 2 new CRM MVP's:
Aaron Elder & Matt Wittemann, welcome to the fold.
MVP - Microsoft CRM
Well come Aaron Elder and Matt Wittemann.
i like to welcome both Aaron and Matt wittemann .....
i want to know hat is MVP .. can u please tell me about this
Most Valuable Professional
I know that .. i wanted to details about it
sorry if i am hurting anybody ...
Aaron & Matt - Welcome aboard!
Larry Lentz [CRM MVP]
MCSE+I, MCSE W2K, MCDBA, MCSA Me...Drop-down Lists and Worksheet Protection
In Excell 2000 I could set "Validate/Drop down List" for a protected cell and when the worksheet was protected the cell could be "edited" using the drop-down list but not otherwise. Moreover, contents of the cell could be changed but not cleared. Try as I may I can't sem to achieve the same in Excell 2003. Any one have a solution?
In Excel 2000, you can select from a data validation list if the source
was a worksheet range, but not if the source was a delimited list.
In Excel 2003, neither is allowed on a protected sheet.
Perhaps you could use a combo box, instea...Formula to Autofill Info based on Other Data
Using: Excel 2000, on Windows 98
Good morning! I'm hoping that someone on here can possibly help me. I
have basic Excel knowledge, but this is out of my skill set.
My boss has given me a project to work on, in which I have a workbook
with two worksheets that I am dealing with. The worksheets are labelled
PRICE and SUMMARY.
On the PRICE sheet, I have several columns. Column A lists the product
name, Columns E list the per page charge for the *red* program, and
Column G lists the per page charge for the *blue* program. Those are
the columns we will be dealing with. All specific inform...Embedded Excel worksheet in PowerPoint
I'm working with an embedded excel worksheet in powerponit. The doc is sent
to me and if I have to edit the worksheet, I find that some cells have
missing characters once I open the worksheet to edit it. It appears that
characters beyond some length (256?) are being truncated off. How do I
resolve this so I don't have this problem again?
This kind of problem may occur if the material was inserted into the embedded
worksheet via copy/paste from an external sheet. A reliable approach is to
open the embedded sheet first, and from that sheet do:
File ...Worksheet disappear when saving on shared workbook
Im Using Excel 2000 SP3, when i try to copy a cells from another workbook
and paste it on the shared workbook, the worksheet of the shared workbook
disappeared after saving it.
...Inserting Rows Problem
I have a list of about 2000 rows. However, in between each of thes
rows I want to insert a blank row that can be used for people to writ
in once the list is printed off. Is there a quick way to do this?
andyp161's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1165
View this thread: http://www.excelforum.com/showthread.php?threadid=26611
If you insert rows it will affect sorting, etc. and be a real pain.
Many posts here want to delete blank rows ...Purge data based on another Excel file???
I am attempting to purge data from a large list based on data in another
document. I have the files I want to remaove in on file and the file I want
to remove them from. There should be simple way to do this no?
...Moving mailboxes using Active Directory Users and Computers
This is a multi-part message in MIME format.
Question: When moving mailboxes using AD Users and Computers from =
Exchange server A to Exchange Server B, what will be the effect on users =
that currently have their mailbox open in Microsoft Outlook? Some of the =
users have Outlook 2003 and some of them have Outlook 2002. Is it best =
to do the move when noone is on? but the thing is in this organization, =
we have so laptop users that may not be on...Only Running New Email Noficication
How do I receive new email notifications in the windows
notification area without having the full Outlook 2002
program running all the time? (and thus using up valuable
resources? We have an exchange server and are not on the
same active directory as the server.
Thank you for any help!
...Copying text value based on long (comlex) calculation
I am not sure how to even search for what I want to do, so please
forgive me if my first post has been discussed and resolved ad naseum
in the past...
Here is my situation:
- I have a workbook that contains multiple sheets.
- Each sheet contains auto parts from different suppliers, sorted by
- Some suppliers have parts that overlap with each other and the
various sheets are updated as pricing and availabilty of parts change.
- I am using a combination of the VLOOKUP and MIN functions to
determine which supplier has lowest cost based on a comparison of part
numbers and price ac...I want a formula to ignore text values in cell references
If text is input into some cells referenced by a formula I want the formula
to ignore whatever text it finds and just calculate the result of the numbers
in cells. How do i do this?
Presently the formula displays #VALUE! where there is text in one or more of
the cells referenced.
In place of A1 use =IF(ISNUMBER(A1),A1,"")
> If text is input into some cells referenced by a formula I want the formula
> to ignore whatever text it finds and just calculate the result of the numbers
> in cells...selecting rows of data
I have an excel worksheet with 4 columbs.
I want to automatically select multiple rows of data according to
search which will partly match one cell in the row and put the full ro
as results in a new worksheet.
If the search string is "New" how can I produce a new worksheet whic
Any suggestions would be appriciated
Message posted from http://w...Formula Problem
I'm struggling with a formula in an excel sheet I'm working on.
I recently created a time sheet for the people in my work. One person
however get public holidays a different method from everyone else -
she only gets half a working day.
My initial formula that works fine is
My ammended ones is
However it doesn't want to w...How to make A1 the active cell in all visible worksheets ?
This is a multi-part message in MIME format.
......so that when i activate the sheet A1 is the cell in the upper left =
corner of my screen.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META content=3D"text/html; ...data links on subsequent worksheets
I have main data entered on worksheet 1 that I have linked to subsequent
worksheets, however when there is no data on worksheet 1 I get 0's printed in
the data space. How doI eliminate the 0?
If you want to hide all zero values on the sheet,
Tools --> Options --> [View] tab and clear the checkbox next to "Zero Values"
In Excel 2007, that's "Office Button" --> [Excel Options] --> then
[Advanced] in left pane and scroll down to the "Display Options for this
Worksheet" and clear the box next to "Show a zero in cells that have a...Delete duplicate rows from a list in Excel
Below are instructions on how to "delete duplicate rows from a list in
Excel". I learned about this tip from the Microsoft Office Assistant
website. However, each time I try step 4, my list is not filtered and
no records are hidden. Is there a secret I am missing to make this
Thanks for your help!
Microsoft Office Excel 2003
Microsoft Excel 2002
A duplicate row (also called a record) in a list is one where all
values in the row are an exact match of all the values in another row.
To delet...Nested query-based distribution groups?
We are currently trying to implement some query-based distribution groups.
Is it possible to create one QBDG that has a couple of rules (for example
all people with a certain job title) and then create another dynamic group
that will start with all the users in the previous group (all people with a
certain title) and further narrow it down with more rules?
Basically does exchange 2003 allow for nested query-based groups? If so, how
do you go about doing it?
Yes they can be nested. You would nest them just like you would nest any
http://support.microsoft.com/?id=82289...IF formula problem
I need to add categories to a downloaded bank statement. I would use
something like Pascal's CASE formula:
a: do x
b: do y
c: do z
Excel doesn't have such formula. Therefore, I use the following nested
names'!$A$7,B73)),"&...*** HOT --- NEW VIRUS ALERT ****
Has anyone seen a new virus going around. We are seeing an email with a zip
file that is labeled price.zip or newprice.zip or 08_price.zip or
price_new.zip. Within the zip file is a html file called price.html and a
folder called price with an executable of price.exe. This thing has it's
own SMTP engine and is starting havoc on our network.
ANYONE SEEN THIS OR KNOW HOW TO REMOVE IT?
for the time being, you might want to block zip files from coming
in...sounds like a bagle variation...see here:
"Fred Yarbrough" <fcyarbroug...rows and columns in spreadsheet
Operating System: Mac OS X 10.5 (Leopard)
Is there a way, in Excel, that I can merge cells, rows, or columns, like I can in Numbers?
Many thanks for your help.