Can you save a pivot table layout?

megnin

Active Member
Joined
Feb 27, 2002
Messages
340
I have a report with 6 pivot tables on it from a workbook with 200 column headings to choose from. It takes me an hour just to select all the row and data fields and they are hard to read because the whole title doesn't fit in the field button.

Is it possible to save a "template" or something that I can just point to my workbook to populate the pivot charts?

This would save me about three hours every morning!

Thanks for any suggestions!!!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
Why do you need to "redesign" the pivot table layout? Once this has been established you should only need to refresh the data and the pivot table will be redrawn accordingly.

Providing you use a range name as the data source for the pivot table, you should be able to place new data into the workbook and redefine the range name to cover the latest data set. As such, your workbook with established pivot tables become a template into which you feed new data.

I'm sorry if I misunderstood your problem.

HTH
 

Forum statistics

Threads
1,144,358
Messages
5,723,889
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top