pivot tables in multiple workbooks using one datasheet?

E

eggman2001

I'd like to create several (let's say 4) pivot tables from one
datasheet, with each pivot table on its own tab for easy viewing.
However, this datasheet contains data for 10 products, and I'd like to
have these 4 pivot tables for each product. This would mean 40 tabs,
which would be too cumbersome to navigate. Therefore, I'd like each
product to have its own workbook, and for each workbook to have the 4
tabs, which contain the 4 pivot tables. I'd like the data to get
pulled from one single source so that I can just update the one source
and then refresh the individual pivot tables. Is this possible to do?
 
W

WallyWallWhackr

I'd like to create several (let's say 4) pivot tables from one
datasheet, with each pivot table on its own tab for easy viewing.
However, this datasheet contains data for 10 products, and I'd like to
have these 4 pivot tables for each product. This would mean 40 tabs,
which would be too cumbersome to navigate. Therefore, I'd like each
product to have its own workbook, and for each workbook to have the 4
tabs, which contain the 4 pivot tables. I'd like the data to get
pulled from one single source so that I can just update the one source
and then refresh the individual pivot tables. Is this possible to do?


"DataSeeker"

It is a start.

I named a range (the data), and referred to the range when I made each
pivot table. Then only select those fields you wish the table to show.

http://www.mediafire.com/?omyj2yt2ndl
 
S

shig+Byetta08

"DataSeeker"

It is a start.

  I named a range (the data), and referred to the range when I made each
pivot table. Then only select those fields you wish the table to show.

http://www.mediafire.com/?omyj2yt2ndl

Yes, I understand and know how to do that part. The issue is that I
want to create a large number (40 pivot tables) off of one datasheet.
Because 40 tabs on one excel workbook would be cumbersome to navigate,
I was thinking about making them separate files. Is this doable?
 
W

WallyWallWhackr

On Wed, 14 Jul 2010 11:28:03 -0700 (PDT),
Yes, I understand and know how to do that part. The issue is that I
want to create a large number (40 pivot tables) off of one datasheet.
Because 40 tabs on one excel workbook would be cumbersome to navigate,
I was thinking about making them separate files. Is this doable?


DL my annual task tracker and see how 53 tabs get used. I put up
dynamic link lists that allow one to "jump" to a tab by a mouse click on
a link, instead of having to scroll a scrollbar first to select a tab.

The links also allow little notes to be popped up for each link.

http://office.microsoft.com/en-us/t...crement-selection-revision-2-TC030008308.aspx



OR... it is the annual task tracker in the below listing. On the info
sheet there are weekly links for all 52 data and all 52 chart tabs.

http://office.microsoft.com/en-us/providers/PN030000658.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top