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...Matrix with imaginary numbers
I am trying to do a matrix that has real and imaginary numbers and I have no
clue how to do it. I can do a matrix with real numbers, but apparently can't
with the combination of both.
in a2 enter a formuala
=randbetween(1,10) and copy down.
as thes are randomedit number they may change time to time so you copy the
column A and highlight A1 edit pastespecial-values
similarly formula in B2 is
=randbetween(-5,5) and copy down and copy with pastespecial values
in C2 type
=complex(a2,B2) and copy down.
you get some sort of random compled numbers.
> I...sorting text & numbers
I have a large list that I want sorted like this:
Ward 2 & 3
When I sort it, it says:
Ward 2 & 3
If I just take out the words Ward and Wards, it makes some of the
numbers into dates, and does something else to some other cells that
returns a big number. Anything I can do?
billjr's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25927
View this thread: http://www.excelforum.com/sh...How to create a task view where completed tasks are omitted
Hello out there!
I'm trying to create a task view where my hundreds
of 'completed tasks' are omitted - leaving all other
tasks that have yet to be completed.
I've searched help and rung the customer support line but
to no avail.
Anyone know how?
Would be much appreciated.
Create a custom view of your Tasks folder with a filter that says "Completed
equals no" (you will find this on the Advanced tab when you click the Filter
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the...Online form ~ I have word 2003 and 2007
I am trying to create an online form that will allow for a limited amount of
characters per field.
Name: 20 Characters at length and so on
Date: 15 Characters
Title of the reading: 40 characters
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader an...tables in word
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
there are only two reasons i use office <br>
1. I like entourage as an e-mail client and general organizer. (Sorry I dislike Outlook intensely.) <br>
2. I have the misfortune that I have to use a god awful windoze computer at work with office as he main application. <br><br>At work in word i can insert an excel table, can I do this in office for mac 2008?
Yes, you can, in pretty much the same way: Insert> Object - Microsoft Excel
Sheet. Unfortunately it is limited to 5 Columns by 10 ...Money 2002
Can missing Form 140 Schedule C line names be added? If
...Word Wrap in Email
I receive email without line breaks at the end of each line. CRM displays
the text as one LONG horizontal line of text. Does someone know of a setting
where I can have the CRM email window automatically word wrap at the end of
the displayed window?
CRM 1.2 /C360 user
...Outlook 2000 and Word Editor
Is there a work around in Outlook 2000 that will display
the digital signature and encryt content and attachment
icons on the toolbar when Word is used as the Editor?
When I uncheck the Word as Editor checkbox I can see the
...Lookup for Part of the number
I need to lookup for a Loan Number from another sheet. However the problem
is sometimes one digit would be added to the end in the other worksheet. Is
there a way to find match for this digit.For the digits in below list I need
to get the match as true for 12345 and 12346 as there is 123451 and 123462 in
List in 1st Sheet
List in 2nd Sheet
Format both column like text!
„Kiran” ezt írta:
> I ne...Word 2003 stops working
Never had a problem with Word 2003 in the 3 years I've had this program.
Suddenly, I have issues.
A few minutes into opening a Word document, or upon attempted close of the
document, I get a popup box with message "Microsoft Office Word has stopped
working. A problem caused the problem to stop working correctly. Windows
will close the program and notify you if a solution is available."
When I close the popup, sometimes a new blank "document 1" opens up
automatically. This happens with both Word docs and Outlook messages.
Don'...french accents in word and in outlook
I suddenly have a problem - when I try to type a question mark or quotation
marks, it types an accented letter. I'm working in Microsoft 7 and I've
checked the language in the control panel. I think I must have hit a wrong
key because this just started today, i had no trouble using these keys
yesterday. Any suggestions??
Perhaps you have a laptop with a built-in International keyboard. If
so, somewhere there's a key that toggles between it and the normal US
keyboard. Locate that key and type it again.
Maybe you toggled/cycled to a different keyboard (by accidentally...Publisher/Word auto saving to C Drive
I teach in a computer Lab and when students are editing text using Publisher,
it takes them to Word andafter editing they close Word, I get a "Permission
Error . . C drive." When I do it on my computer (has some admin. privileges)
How and where does one change where Word 'appears' to automatically save?
Can this be changed without giving all students Administrative Privileges?
...How do I modify the value of a checkbox in a word document using C
I am a bit of a newbie at C# and am trying to set up a document that I will
be modifying based on values from a database. I am using a word document,
because it is the "official" reporting form required by my company. I can
open the document, and write to bookmarks that I am setting in each table
field, but I need to know how to manipulate a checkbox. Can anyone help me?
I have edited this post because I have added some other code. The document
file I am using is a document that has everything inside a table. I have
bookmarked all the text locations, and...How do I enable Outlook to view the Public Folder while being able
How do I enable Outlook to view the Public Folder while being able to Mail
Favorite Folder windows. We are on XP pro along with Outlook 2007 using 2008
Small business server standard that has 2007 Exchange server.
"kdepc" <firstname.lastname@example.org> wrote in message
> How do I enable Outlook to view the Public Folder while being able to Mail
> Favorite Folder windows. We are on XP pro along with Outlook 2007 using 2008
> Small business server standard that has 2007 Exchange server.
Please...OWA 2007 Performance issues
I have been using Exchange 07 for a couple of weeks now and really like it.
But, I'm having performance issues with OWA from the outside world.
Internally, OWA is lightining fast, but from the outside, it is as slow as a
dog. So I don't think it is the server that is causing this, but rather my
bandwith to the outside world.
Has anyone else experienced this? Does anyone have an idea how much
bandwidth is needed for OWA to perform well?
OWA 2003 was much faster than 07 and I'm wondering if I made a mistake
"Jay Becker" <JayBe...How I can print full text bigger than column, in repeat column
When I print statements with repeat columns in excell which have text bigger
than repeat columns, complete text is printed on all sheets except first
sheet. How I can overcome this problem?
I want to print complete text in repeat columns, which is expanded to other
columns which are blank.
...removing black lines
Sometimes I type an underline bar across the page. At the end of the page
I'll hit the return (enter) key. When I do, the underline bar turns into a
big black bar. Then I can't get rid of it. It just stays there. How can I
get rid of this black bar?
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> &...Missing grid lines
I have a standard worksheet that covers the array of cells A4 to Q70 that
originally included grid lines. Unfortunately the grid lines have vanished
from the segment covered by cells A14 to E65. Using Tools/Options/View to
check or uncheck the Gridlines box turns the gridlines on or off but does
not restore the gridlines in the bare segment. I have tried everything I
could think of to get rid of this annoying situation including copying and
pasting to a new worksheet. Nothing I have tried works. I would be grateful
if someone would help me solve this problem
sounds like the cel...Office 2007 Professional: Help Files Issues
I cannot find a solution to this odd issue and before I submit a support
ticket I thought I would ask the community.
We have office 2007 professional (volume licensing) on a Window 2003
terminal server. We have a few users out of a bunch that get the "This page
is unavailable" I have tried the Refresh and back. I've tried online and
offline modes. In offline I get the table of contents to the left but same
unavailable message when I click the links.
I noticed on testing some other users, that apparently never used the help.
That there are some prompts...Removing the (1) figure before phone numbers
How can I delete the (1) figure in front of some of my phone numbers?
Was there more to your question that you did not post?
"Phil Dee" <PhilDee@discussions.microsoft.com> wrote in message
> How can I delete the (1) figure in front of some of my phone numbers?
I have a GIS application which uses .dbf files (not sure if they are actually
Dbase files). When I need to append data (fields) to the files, I have a big
problem in that excel 2007 no longer allows save as / export to .dbf files.
If I try bring the data in MS Access and save as .dbf files, I have untold
problems with the GIS application... The only way I have been successful with
this is to find a user with an older version of excel, insert the data as
database columns and then save as .dbf
Any suggestions as to how I can get around this with out purchasing a
...CListCtrl Tile View (repost)
(This is a resend of an earlier post; sorry for the duplication, but I
had to fix my newsgroup account.)
I'm trying to use the CListCtrl's tile view option in MFC under XP, but
the documentation for this is woefully inadequate. Can anyone point me
to some sample code that shows how to use this?
Specifically, I'd like to know the following: - What does the
"cColumns" and "puColumns" fields in the LVITEM struct mean when
applied to a tile view? Do they include the icon as a column? - The
LVTILEVIEWINFO's dwMask field can contain LVTVIM_COLUMNS; does th...Inserting photos in Word
Hi to everyone.
I use a doc file as a form. It includes text and photos (and some links)
The problem is about photos. They must located in particular positions in
the doc and under every photo must have a relative title. The photos i put in
that form have different sizes and deform the text and generally the
structure of the whole form.
Is there any way to determine some stable rectangles in particular points in
the doc with desirable dimensions, so every time i add the photos the whole
form to remain stable?
Also what about the specify title below?
Thank you all for your time.
I bet/ho...connecting cells with connector lines
Is it possible in Excel (2007) to draw a connector line (with or
without an arrow ...) between two cells in a worksheet, so that the
line-tips will follow their cells even when the latter are moved ?
On Feb 25, 7:00=A0am, Michaelprem123 <michaelprem...@gmail.com> wrote:
> Is it possible in Excel (2007) to draw a connector line (with or
> without an arrow ...) between two cells in a worksheet, so that the
> line-tips will follow their cells even when the latter are moved ?
The line will automatically a...