Pivot Table/Multiple Workbooks
Is there anyway to create a pivot table using information
from multiple workbooks (not worksheets?)
I have 3 files:
All files have same headers but each file represents a
different month. How can I create a pivot table using
these 3 excel files?
I also want the pivot table to get updated everytime I
make a change to one of the excel files.
If this is doable, what is maximum number of files that I
can link to that pivot table?
You can use a pivot table across mulitple workbooks by using the "Multiple
Consolidation Ranges" in the ...AdventureWorks Demo
Could anybody please provide me with a good example of a pivot table using
the AdventureWorks VPC demo data. I really want to show the potential of
the pivot tables but can't really find a good X/Y axis combination to
illustrate it well.
Any suggestions anyone?
Thanks in advance.
Using blabla.Split(whatever) you can split up a text-line into its
constituent elements of an array (as you will know well), my question:
is there code to do the opposite, say after you have nullified one of
the elements of the array? Please give simple example, no reference or
On 22/03/2010 11:12, Zach wrote:
> Using blabla.Split(whatever) you can split up a text-line into its
> constituent elements of an array (as you will know well), my question:
> is there code to do the opposite, say after you have nullified one of
> the elem...How to calculate of % in Pivto table?
Could you please provide the details on how to calculate % throu
I Have an excel-sheet that contains a columns as Priority (High, Low,
Using Pivot table, I added the column Priority in Colunmn Area and Data
area. It is showing as numbers. I wanted to have a separate column
that shows the % of a grand-total (as a separate column).
How to do it?
I don't know that you can display it as a separate *column*, but it can be
displayed as a separate *row*...
Drag the Priority field from the Pivot Table toolbar to the Data Area for a
sec...Outlook Web Access: Error on Page
The basic version of OWA works fine (other than frustrations with selecting
email addresses from GAL and contacts folder when composing an email;
suggestions on that are welcome), but the Premier version only half-works on
some machines. Messages can be displayed, but clicking any "button" to show
the address book, reply to, create, or forward email, etc, all create an
"Error on page" message in the status bar. I've experienced no other java
errors on other pages/sites. Does OWA require or prefer Microsoft VM over
Sun's Java, or does ActiveX require any special c...Any way to split a transfer?
Money 2006, Standard-- Advanced registers. Here's the scenario. I owned
shares in Credit Suisse New York Municipal Bond Fund which has decided to go
out of business and liquidate in October. So I closed my account, making an
ACH transfer to my Chase checking account, where I parked the proceeds.
There was one ACH transfer, say for $15,100.00, but there were actually two
transactions, a sale of all my shares for $15,000 and a (tax-exempt)
dividend payment of $100. I entered these as Sell and Dividend transfers
to my checking account. They showed up correctly in both the Chase ...Sotock status value recreation through IV30300 table?
I am trying to find the difference between my goods received report and my
stock status report.
I have managed to recreate the goods received report through a view off the
IV10200 table. These values agree to the Goods received report's values (But
this does not help).
However if I try and recreate the stock status report off the IV30300 table
my values do not agree.
I realise one issue is the transfers in the report so I am trying to use a
view like below to rectify this problem:
Create view ERP_IV30300Breakdown as
TRXSORCE,DOCTYPE,DOCNUMBR,DOCDATE,HSTMODUL,CUSTNMBR,I...Converting Access 2000 table to Access 97
How do you link an Access 2000 table to an Access 97
database? Thanks for your time.
...Table of Authorities entry sorting
Is there a way to change the sort order of entries generated in the Table of
Authorities (Word 2007)?
I need the entries to list in order of first appearance (i.e., first "long
form" cite), not alphabetically. No need to group by category (cases,
statutes, rules, etc.). (By "section," I don't mean Word-defined document
sections, but, rather, heading/sub-heading sections, as in Section I.A.1.,
Section I.A.2., Section I.B., Section II.A., etc., of the document.)
Even if I use custom TOA categories and assign all authorities within a
heading section ...pivot table
Hi - have just switched to XP
In a pivot in old excel I use to to click in a subtotal
field eg "Europe Total" and excel would automatically
highlight all subtotals at that level. It just meant I
could colour the row and it would apply to all of the
subtotals - how can I do that it XP ?
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
Click on Enable Selection
To format the subtotals --
Move the pointer to the left of a subtotal heading in the
When the black arrow appears (like the one that appears
when the pointer is over a r...Manipulating footer to return page number.
With assistance from Graham & Gerry I now have the correct fonts in my
Next (and last) problem is to append the page number to a string being
inserted in the footer, the page number to be preferably to be formatted as
"01","02" .."99". Will never be more than 99 pages in a section.
One way which almost meets the requirement is to append a PageNum field to
the string, but as I am manipulating the footer using the code below, I do
not know how this can be done.
Again any help much appreciated. Portion of Code below.
sStamp = ...change page order
I have been trying to print a newseletter. It is 8 8.5X11 pages - or
4 11X17 pages. In the 2003 publisher I was able to change the page
order on the layout tab of the page setup so my printer would print it
correctly. In 2007, I can not figure out how to change the page order
in order to print the newsletter. So it is printing it all funny with
multiple pages on top of each other. How can I fix this to print
Printing from 2007 is an adventure to say the least.
Is this setup as a booklet? Do you have a duplex unit? If not...
print page range.. 1,6,3,8...Page Numbering problems
I have a spreadhseet with 12 worksheets. I want to print the Page numbers
(starting @ 1) on each of the 12 using a footer and clicking the # icon. I
select all 12 sheets at the same time and do this. However, Page 1 show for
all of them when they are all selected. Additionally, I have tried to make a
PDF of the 12 sheets and it is not allowing me to save one PDF with all 12
sheets. It is asking me to name 12 different files with 1 each. I believe the
2nd problem is based on the first. Any ideas of how to fix this? Thanks!
IF - AND ONLY IF - YOU HAVE 1 PRINTED PAGE PER TABBED SHE...Error when i split a database
I created and split a database. When i did this it caused the bitmap
i was using as the background to be distorted.
When I open the particular form the top of the graphic appears but
when it gets to the tabbed section on the form it turns white and then
reappears after the tabbed section.
Before I split the database it appeared as one solid graphic. I've
tried changing the graphic around but the same problem occurs.
Anyone have any idea on a solution?
You do have a copy of the complete mdb right? Try splitting it again but this
time remove the graphic from the form and try placing...How to number pages in Publisher at page 10 and not p 1 please
I wish to have ten un-numbered pages at the start of my publication with page
11 being page 1. Can I do this please?
Go to page 11, Insert, Section, Check begin a section with this page, start at
page one. Okay out. Insert page numbers. If you have a two page spread you may
have to insert page number on both sides.
"Barbara Eek" <Barbara Eek@discussions.microsoft.com> wrote in message
>I wish to have ten un-numbered pages at the start of my publication with page
> 11 b...How do I remove split a split window?
I selected "View" "split" and now have a split window. How do I remove the
"Norm" <Norm@discussions.microsoft.com> wrote in message
>I selected "View" "split" and now have a split window. How do I remove the
Same way as you split it....
Or double click the "line".
http://www.wimgielis.be = Excel/VBA, soccer and music
> "Norm" <Norm@discussions.microsoft.com> wrote in message
> news...Life Insurance table in HR module
Is there any way to increase the decimal places allowed for Insurance Rates?
For example our payroll is processed weekly, but the life insurance rate is
monthly. So when it is $0.25 / 1000 per month that is $0.577 /1000 per week
and the system ONLY allows 2 decimal places.
Anyone worked around this?
Yes, allow three decimal places for deductions.
Charles Allen, MVP
> Is there any way to increase the decimal places allowed for Insurance Rates?
> For example our payroll is processed weekly, but the life insurance rate is
> monthly. So ...Split database
I apologize for these basic questions. I have set up a simple database that
a few users will have access to. I've split it, and both the back end and
front end are on a server that everyone can access but the back end is in a
hidden folder. My questions are:
1. How do I set up the MDE? I couldn't find this in Help.
2. How do I "put" the MDE file on each user's computer? Is it in the same
folder as the front end on the server? Can't they just access the front end
on the server?
Thanks in advance
> I apologize for these basic questions. ...How do I center data across multiple cells in excel without mergi.
How do I center data across multiple cells in excel without merging the cells
Bernard V Liengme
remove caps from email
"lmark" <firstname.lastname@example.org> wrote in message
> How do I center data across multiple cells in excel without merging the
Select the cells in questions and do format>cells>alignment and check center
> How do I center data ac...Pivot Table Protection
Pivot Tables in my workbooks cannot be refreshed if the sheet is protected.
Here's what I've done:
Set up my worksheet.
Formatted cells that I wish to be locked.
Selected Tools>Protect Workbook
Selected Tools>Protect Worksheet
Clicked the following checkboxes: Select unlocked cells, Use Pivot Table
The actual area of the Pivot Table in my worksheet is unlocked. Whe I select
the pivot table in the protected sheet I cannont refresh, but I can format
and create charts.
Any help would be appreciated.
You could record code as you unprotect the sheet, refresh the...about SetColumnInfo on the splitted window
I call CreateStatic and CreateView to split the window into 2 parts.
In order to adjust the size of the splitted windows dynamiclly,I hanlde
WM_SIZE message.I want to specifies a minimum width for the splitter windows
column in pixels.,so I call SetColumnInfo.
But it don't work.I can still let the splitted windows no-size.Please see
the following code:
_________________________...Defining a table
Hi I am defining a table using Excel e.g where the headings are regions,
customers, etc. How can I move the headings, regions, customers, etc,
and shown them on top of the columns instead of the A,B,C columns.
A, B, C, (or if you are running xl in R1C1 format, 1, 2, 3) is how excel
essentially works. You really can't. If you don't like it, you could always
go under Tools|Options, View tab, and uncheck Row & Column headers. (assuming
you are not using xl2007).
If you really are a new user, I don't recommend it, as your formulas require
Row and Co...Conversion of Data in Tables
Trying to do some data mapping of user information from our old system
to our new one.
1 Main Tables (old system)
(Contains 3 fields: UserID; Function; Location)
2 Conversion Tables
(Contains 2 fields: OldFunction; New Function)
(Contains 2 fields: OldLocation; New Location)
Need a query that converts entries within Table 1 (Function and
Location fields) to be as per the Conversion table fields. I can do
this when it's just one on one mapping by linking the tables, however
this will mean that if there's no c...Tab pages: How to change background color
Hi, I've added 6 tabs onto a form. Although the form itself can be
formatted with different background colors, the tabs themselves cannot
(as far as I've been able to try). Perhaps there's a VBA code that
will allow me to change the tabbed page background colors? With 6
tabs, I want to make sure the user will unmistakably associate the
selected tab with the data being updated on each page.
Have a look at http://www.fontstuff.com/access/acctut12.htm
On Sat, 18 Aug 2007 14:23:42 -0000, mcheng <email@example.com>
>Hi, I...Payment Missing, found some applied invoices in the table PM10200
"Error! This document cannot be marked for voiding. It has been either
partially applied or is on hold" shows above error to me when I tried to void
transactions & also I can't able unapplied invoices because payment is
missing. I unable to see the payment. But I found some applied invoices in
the table PM10200 when I delete the invoices from there it becomes history.
Just I want to delete this payment. How can I do this? can anybody help me to
get resolve this issue.
Thanks in Advance
Please refer the KB Article :858373.It will be helpfull