automating a pivot table
When using a pivot table, is there any way of
automatically selecting from a drop down menu.
By this I mean if I can select one of 5 colours,
If I put "red" in cell A1, can the pivot table be made to
take the value in cell A1 as the colour selection, rather
than me selecting red from the drop down list.
thanks in advance
You can add fields to the page area. When you select from the dropdown
list in a field there, the table is filtered to show only that item.
> When using a pivot table, is there any way of
> automatically selecting from a drop down menu.
&g...Input cell on Data Table will not work
I have re-created the example from Microsoft Excel Help from "Creating a one
variable data table", and when I select "Data Table" then select "Column
input cell" I select the cell specified in the example. I receive the message
"Input cell reference is not valid" The same thing happens when I try to
replicate the two variable data table from Microsoft Help.
Note that you have to select a "single rectangle that is more than one row
high and one column wide"
"Sarah Bee" wrote:
> I have re-created the ex...Exchange 2003: Contacts Display Name
We recently migrated to Exchange 2003, and are noticing a slight
problem. Under Exchange 2000, when an internet user sent us a message,
and that user was a contact in Active Directory, the display name we
set in AD would show up in e-mail, overriding what the user set at
home. Under Exchange 2003, this is no longer the case. Are we missing
a setting somewhere??
Windows 2000 AD
Exchange 2003 on Windows 2003 Enterprise.
Thanks for any help
...Automatically Refresh pivot table
In Excel 2000, I have a spreadsheet with several table. Some of the tabs
have been filled with data from an Access MDB. I have manually created a
second tab which contains a pivot table based on the data I passed in to the
The source data tab always has a different number of rows every time the
Access MDB is executed.
How can I automatically refresh the pivot table?
What is your trigger to refresh. When you open the book or every ?? minutes?
There are some options in Table Options. Right click the pivot table and
select Table Optio...auto category transactions by payee name
Money automatically categorizes some items. Can I
customize where they go by keywords and such for every
time I import transactions?
...Do Long Names Corrupt?
I have an Access 97 database that I've been developing since '98.
All seems to have been fine until about 5 years ago. The database exits or
crashes for no reason. I have been trying to figure this out for years, but
cant seem to identify the cause. I've tried all kinds of tips on corruption
Recently I was able to reproduce the problem.
I went directly into a design view of a report and the system exited out,
back to my desktop.
The query driving the report had a long name of "Quote Like Status Summary
by Cust". I then changed it to &q...Pulling specific data from table field
I am having a problem figuring the right way to pull specific data from
within the text of the table's field and separating it into a unique field
Anyway, my problem is that I need to copy a user's first name out of a field
that contains system user information, and then pull the last name out
separately as well, both uniquely. I don't mind having separate queries to do
this (although one would be preferred of course).
Example of field data: ABD 000000 111, Doe John, R, W, T22222222, T333333
The ABC and 111 are constants within ...Excel 2007 Pivot Tables
How do I set my pivot table so that it does not display any sums of values
that are equal to zero?
You can use conditional formatting to set the foreground colour to
white if the cell contents are zero.
Hope this helps.
On Mar 10, 2:19=A0pm, Barb Reinhardt
> How do I set my pivot table so that it does not display any sums of value=
> that are equal to zero?
> Barb Reinhardt
...Pivot Table suppresses/hides zero values
I have a list of retail chains... products and amounts sold.
My pivot table does not show any of the retail chains that don't have sales. I've added zero data in the Access table I'm pulling from, but that doesn't seem to help. My Pivot table options and my general option are NOT set to hide zero values. It's something the table seems to be doing automatically.
Anyone have a suggestion?
Check the field settings (double click the grey field names) to mak
sure "show items with no data" is checked
Message posted from http://www.ExcelForum.com
...clearing values of cells in named range(s) so the cells are empty
I am working on project where i paste data-set into a worksheet
(sheet1) , do several calculations and put the results specific cells
on sheet2. I am using named ranges for the cells in sheet2 that
receive the data. WHat i am trying to figure out is a way to set the
cells in the named ranges on sheet2 to 0 or "" before starting the
routine that does all the calculaions. This way I can be sure that the
data on sheet2 belongs to current set of calculations. Thank you in
advance for any advise. BRC
Assuming one of the named ranges is name SomeRangeName, then this state...Structured Table Refs in VBA
I'm confused about the relationship between tables (using structured
references) and ranges.
I can work on individual cells from a table column, similar to working with
a range, using-
Dim oSh As Worksheet
Set oSh = ActiveSheet
Dim r As Range
For Each r In oSh.Range("MyRange[ColumnName]")
r.Value = 10
But if I try to create a range object from a table, using any of-
r = oSh.Range("MyRange")
r = oSh.Range("MyRange[#Data]")
r = oSh.Range("MyRange[ rowvariable, [ColumnName]]")
I think I am fai...Best approach? Native Excel pivot for a SQL table
We've researched how to have an Excel pivot table use as its source a table
generated by a SQL-based program. There are a number of ways mentioned in
the Excel documentation. At least one seem complicated to even test--like
having to create a data definition. We're happy to do the work but are
unclear which method is best, and whether one or more methods is risky. We
first probably will have to create the pivot table using a sample table with
the right field names, and then ideally will point it somehow at the real
table, which will be on a different system and at a different path....Pivot Table with interactive Chart
I have a cube with some KPI's. One of my details is a parent-child
The pivot table is working great with my KPI's - but what I'm wanting to do
is click some of the KPI values and have a corrosponding graph update. Can
I put in hyperlinks in a pivot table view that either updates a graph in my
worksheet or I can call a Reporting Services Report that pop's up a window?
...Updating a table
I have query that relates to a table and i want to be able to automatically
insert a comment into a range.
I.E Table column is called Report name. I want to open the query and have
it ask me the name of the report. When i enter it i want it to
auutomatically enter the name in the column so that all the other information
that i add afterweards is associated with the report. I then want this info
to save when i exit.
Can anybody help?
...Named range row/column reference #2
thanks. understood, and that does work well.
I would still like to be able to reference within named ranges usin
offsets from the beginning of the named range. Once I have the offset
they would serve as references into other named ranges of a simila
*Is there a way to get vStudentNbr and vTestWeek as relative reference
to the beginning of their respective named ranges? *
(yes I am a VBA newbie!! and I am not yet writing the most efficien
code LOL :)
Urklnme's Profile: http://www.e...One Input, Two Input Data Tables.
Thank you very much for being close to us through this
tool, even thousand of miles are separating us. I have
contacted you before and you were too kind for resolution
Please advise us with visual basic macro in case that the
user would like to use "Data - Table" to include one
equation. The equation contain more than one variable in
the Row Input Cell, and more than one variable in Column
A short response only for the Article Number for easy
reference to find the article will be greatly appreciated.
YOU MAY HAVE ANOTHER TOOL TO...Problem writing a macro to Hide Detail in a Pivot Table
I have a pivot table with a row I want to Hide Detail for. I recorded
macro by clicking on the row heading I want to hide, then right clickin
and selecting Group and Outline and then selecting Hide Detail. Thi
all worked during recording, but when I try to play it back I get
Run-time error 1004; Unable to set the ShowDetail property of the Rang
The recorded macro is:
Selection.ShowDetail = False
Range E7 is the Row label of the data I want to hide.
I've recorded many macros and understand a lot of the quirks abou
pivot...IS there a way to find the name of GIF file over Excel cell
Please help, please!!!!
Is there a way to find the name of GIF image over a sheet cell. these
images are small tick marks and I need to store the count of these
images into each respective cell. There can be upto 3 GIF images at the
top left side of a cell.
gggkkk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29653
View this thread: http://www.excelforum.com/showthread.php?threadid=493638
Over a specific cell?
You can cycle through all the pictures and look to see...Making field from Access table my To line in an email
I have created a database with all my contacts and thier
information in it. I need to send an email informing the
people on my table to save the date for my wedding. To
save money costs I want to email the invites to those who
have email. How do I take the email addresses from my
table and place them into the To or BCC line or my yahoo
There's information on this and other email questions on Tony Toews's
pages at http://www.granite.ab.ca/access/email.htm
On Fri, 15 Aug 2003 13:45:26 -0700, "ghummel"
>...Dns lookup or name resolution
There is a problem with a component on my network and i am told to check if
i can resolve the servername from a workstation. How do i resolve a
servername? (or any name for that matter)
I have xp pro and windows server 2003
Using nslookup utility from the command-line.
MVP - Exchange
NEW blog location:
"MSExchange2003Student" <exchangestudent@newsgro..."ERROR: Posting to table ..." message
A user had their computer crash while they were posting receiving transactions.
When they rebooted and logged back into Great Plains, they got a message
that posting was interupted but they click OK to continue posting.
The following messages were found on the Receivings Posting Journals:
"ERROR: Posting to table POP30390. Restore from a backup if possible."
"ERROR: Posting to table POP30310. Restore from a backup if possible."
They appear to be for one transaction, not for the entire batch.
I looked in inquiry, the transaction is there under historical rec...Domain names changed
i'll try to explain the best i can!!
We currently have 2 sites, 1 Novell and 1 Microsoft. The MS Exchange
server has all the relevant groupwise connectors configured to allow
emails to be sent and received from both sites but i've just noticed
I've sent an email from my personal account, which is firstname.lastname@example.org, to
the following recipients:
When the email arrived, the username had stayed the same but
theredomain.com, ourdomain.com and anotherdomain.com had been changed
to show o2.co.uk (i.e....Excel 2007, pivot table format issue
Suddenly the numbers in my pivot tables are reverting to dates! I can
reformat to numbers but on refresh they revert to dates. Help please?
...Name change and email problems
I have a user who has gotten married and asked that I change her name to
reflect her new name. I made the changes to her display and logon name and
also set up a new SMTP address. Now the problem is the user cannot access her
mail using POP or IMAP. OWA works just fine. I have run into this problem
before and my only solution was to delete and recreate the account from
scratch then reattach the mail box. Is there any other way?
did you change her "alias"?
Susan Conkey [MVP]
"Steve" <Steve@discussions.microsoft.com> wrote in message
Using Word V. X, recently the "handles" that one can use for moving
tables have disappeared, I cannot seem to make them come back. I can
still position tables by specifying location but this isn't nearly as
quick as using the handles. This happens whether I am using a new
document, an old one that has been saved many times. Doing the
table-to-text /text back to table manuver has not helped. What I am I
missing? Downloading the latest upgrade has not helped.