Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot table sources

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Sources

Pivot Table Sources

ResolvedVersion 2007

Mary has attended:
Excel Intermediate course
Excel Advanced course

Pivot Table Sources

Hi
I have pivot table and would like to create another based on the results of the first.

How ca I do this?

RE: Pivot Table Sources

Hi Mary

Thanks for your question

A pivot table must be based on an Excel database. That is a list with column headings and no row titles. A pivot table is not in this format and therefore you cannot base another pivot table on it.

If you could give me some more detail about what analysis you are attempting, I could perhaps give you further guidance.

Regards

Stephen

Thu 11 Mar 2010: Automatically marked as resolved.

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.