Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that
have subtotals associated with them (automatically generated via the
pivot table). I need to to take the subtotals for 2009 and 2010 and
calculate the % difference.
Here's a screenshot of what I'm talking about:
Is this even possible or am I going to have to do this manually?
Hi I have'nt seen the screenshot as am at work , go to Pivot
>This is what I need to do: I have rows of ...No content in message field anymore
For the last two days when I open my email client I see no content in the
message field. Each email is blank with an attachment paperclip in the upper
right hand corner. When I click the paperclip I have the choice of a txt file
(which will not open up) or an htm file which will open. This is driving me
crazy and I don't want to get rid of windows mail...any suggestions on how to
Which antivirus are you running? Some of them cause problems with
Windows Mail over time.
Try running the various repair functions in the WMUtil program:
http://www.oehelp.com/...Calculated Field in form to table
Can you take a calculated field from a form and pull it in to a table??
...PIVOT tables and publishing thrm on a webpage
Is there a way to publish a pivot table in a html page but still kee
exactly the same funcitonality that you have on a Excel spread sheet
either by converting it to a java applet or something else . Any hel
would be much appreciate
Message posted from http://www.ExcelForum.com
...Automatically filling in "full name" field
I would like to add the "fullname" field to the Contact form. Is there
someway to make this field automatically fill in with the information from
"firstname" + "middlename" + "lastname" + "suffix"?
If this can be automatically filled in, could the field later be manually
You will find that if you add the fullname field to the form, it will be
greyed out, you can't type into it. It will be populated after you create a
new contact and enter the first and last names and save the contact. And it
will change if you change the f...Exchange updates?
Maybe I'm getting blocked at the firewall or something, but is there a
process similar to Windows update that will tell you all of the recommended
critical Exchange updates that need to be applied to your server? TIA
"SilverICE" <SilverICE@discussions.microsoft.com> wrote in message
> Maybe I'm getting blocked at the firewall or something, but is there a
> process similar to Windows update that will tell you all of the
> critical Exchange updates that need to be ap...Pivot Table question #4
I have spreadsheets that take data via a pivot table from an OLAP cube that
is held on a terminal server.
The spreadsheets hold figures entered by me and figures obtain from the
I want to enable the automatic update on the pivot table but the pivot table
is sorted by a project number obtained from the OLAP cube. My problem is if
a new project is added to the OLAP cube then it is automatically selected
from the drop down list. I want to be able to turn this off so that it only
selects the project I have previously chosed. For example if I have selected
the filter nu...Last Updated Filed
What event triggers the update of the field LastUpdated in the Items table?
This is a multi-part message in MIME format.
Depends on what version you have as its been fixed and broken many times =
over the last year!=20
Look it up on CustomerSource hotfix list.
Check Poin...table and form not calculated in synch
Help says to open a piviot table but I am having trouble making my columns
add up to total for each indivudual ID. The totals are being calculated only
in th e form view which does not up date the original table and does not
transfer to a report. How can I get a feild to calculate specific feilds so
that I can run these reports?
...Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different
tables that are created dynamically by a query. The data for these will
but I would like to simply pull the data from these tables to create a report.
The tables have the following information:
1. Company Info (name, address)
2. Customer Info (address, name, etc)
3. Customer Order (products, price, other info)
4. Invoice Info (ID, GST #, etc)
I realize I could have created a table with relationships but the data above
dynamic as there are 4 different companies and based upon user inp...print folder in table style
My CU wants to print a list of files in a folder. He use Outlook 2002.
Click Other Shortcuts -> My computer -> choose a folder -> Click the print
icon on toolbar -> choose Table Style -> print preview
The header and footer can be printed properly. However the content is
blank. I mean: there is no file in the list.
I can print properly at my side. However at the CU side, there are 2000
users encounter the same problem. And there are four kinds of printer. All
have this problem.
Any suggestion? Thanks!
...Chart Stopped Updating
I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
when you saved into 2007, you keep the old file format or use the new format?
if using new, pls make sure you are using xlsm.
if you are using the compatibility mode, please check make to make sure you
click the security setting to low.
...Take a look at the correction update
Content-Type: multipart/related; boundary="xuzikszmnh";
Content-Type: multipart/alternative; boundary="uvrjpsddwlnwfr"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to maintain the sec...GP Extender Tables Question (GP9)
I have created an Extender window with 3 Fields (let’s just say price 1,
price 2, price 3). I can see where it got created in table EXT40100, field
User_Defined_Prompts_1 etc and I can also see where the data is stored in
EXT00103. What I don’t see is where the prompts from EXT40100 are in its own
rows so that you can link them to EXT00103 for reporting purposes. I know I
can hard code the flags to their proper values in Crystal or set up my own
custom table to do it but I would have thought that Extender will have a
table like that. Am I just not seeing it?
The prompts ...Do Pivot Tables have an automatic data range expansion?
As I add new rows of data to my data base, my pivot table will not expand to
include them after refreshing. Is there any way of setting the pivot table
to include the entire database regardless of its continuously growing size?
Right now, as I add a new row of data I must delete my old Pivot table and
create a new one from scratch. Is this normal?
You can use a dynamic range that grows/contracts with your data.
Debra Dalgleish explains it all at:
> As I add new rows of data to my data base, my pivot table wil...Money 2007 Internet Updates
I presently use Money 2002 Deluxe and only use Internet Updates to update my
portfolio stock quotes and it's free withing Money 2002.
With 2007 it says Internet updates are only good for 2 years. Does that
mean after 2 years it won't update my portfolio as Money 2002 does?
If yes, I'll just stick with my 2002 version.
"rlastar" <email@example.com> wrote in message
>I presently use Money 2002 Deluxe and only use Internet Updates to update
> portfolio stock quotes and...Automatic Insert Rows VBA
A Very Good Evening All,
I have a macro that runs: advanced filter/copy to another
place/unique, between two worksheets (Column A in each
worksheet being the identfier; worksheet1 is source
data,with duplicates of identifiers; worksheet2 is formula
driven from the sum of the unique identifiers in
However...I would like the macro to automatically extend
the rows in worksheet2, to accommodate the ever increasing
rows of worksheet1
Here is my specific code
worksheet1 = "Invoice Record"
worksheet2 = "General Report"
' A...cannot see updated DLs in Outlook
With my usual Exchange admins both on vacay, I've been charged with
creating/updating distribution lists.
We're in a Windows2003 and Exchange2003 environment.
I've changed permissions on the DL. Updated them to Global/Distribution in
AD and synched the DCs using AD Sites and Services (for grins). Still
nothing in the address book on the client side.
I'm going to peruse the event logs on the Exchange box next, but meanwhile
if any of you have an idea of what's going on....
You can try the following steps (very basic):
1. Go to ADUC, properties of any one DG...Updating Financial Institutions for Money 2004
I have money 2004 and I am setting up online services. American Funds is not
listed as a financial institution. I know American Funds IS listed for Money
2006 after viewing the list of financial institutions supported by 2006
online. Anyone know how to update financial institutions for Money 2004 or
do you know why it's not there?
In microsoft.public.money, "C Jensen" <C
>I have money 2004 and I am setting up online services. American Funds is not
>listed as a financial institution. I know American Funds IS listed f...Integration Manager
I have a customer integration which runs fine the first time. If I re-run it
it fails with the following message:
DOC 1 ERROR: Internet Information for Address 'PRIMARY' already exists;
The destination edit mode is set to Insert and Update.
You want to take out the your address information for the integration manager
on the next reruns. There are certain fields that will work with integration
manager only once. After the first run, the field is then a Key field on
another table, in this case the "Address ID" fi...Automatic number fill-in on Labels
Is it possible to have word automatically fill in a series of numbers on
Labels. I need a set of labels, counting by fives, from 1 to 3500. Just
wishing I didn't have to key in every number....0001-0005, etc.
Microsoft Word MVP
"Bridgett" <Bridgett@discussions.microsoft.com> wrote in message
> Is it possible to have word automatically fill in a series of numbers on
> Labels. I need a set of labels, counting by fives, from 1 ...Rules don't work automatically anymore
My rules don't run anymore. I have to run them manually. I know there's a
known problem as far as not running when you first start OL up, but even
when its been running, they don't seem to be working. If I go in manually
and run a particular rule, though, it works.
Ken Isaacson <No Spam> wrote:
> My rules don't run anymore. I have to run them manually. I know
> there's a known problem as far as not running when you first start OL
> up, but even when its been running, they don't seem to be working.
> If I g...Internet Connections / News Updates Money 2004
I know that my internet connection works. I can view
webpages with IE and also Money 2004. When I click on the
update now links the message says that it goes through but
the updates are not showing up. Also, when I am trying to
setup my passwords for my bank accounts it needs to
connect to the internet but It says I have no internet
connection set up. I am using Adelphia Cable as my ISP.
I contacted them and they say it is not their end why
Money cant connect. I was given a cd to automatically
setup my internet I did not manually configure anything.
If you know anything about th...no updates since 2008
I am trying to update an old machine, but when I go to the express otion, it
comes back with no updates are needed. I look on the history and the last
updat is from June of 2008. Any clues why this is happening?
> I am trying to update an old machine, but when I go to the express
> otion, it comes back with no updates are needed. I look on the
> history and the last updat is from June of 2008. Any clues why
> this is happening?
No clues as to what OS and what service pack it might be? Even what
architecture (32-bit or 64-bit) the OS is... So - n...Update Quotes #2
Is there any way to permanently disable the "Update Quotes" feature? I do
not have a stock portfolio and the Update Quotes feature takes upwards of 5
minutes to complete. I know that I can turn it off for each session, but I
would rather just permanently disable it.
Which version of Money?
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedback