I am working in Office 2007. I am working on formatting a pivot table. I
have used the "designs" to create a custom design to apply to all my pivot
tables. The problem is that once I create a design I can only use it in that
worksheet. Is there a way to make a design that you have created be
available within all of your worksheets? Through a template?

On Aug 26, 7:28 pm, dss wrote:
I am working in Office 2007. I am working on formatting a pivot table. I
have used the "designs" to create a custom design to apply to all my pivot
tables. The problem is that once I create a design I can only use it in that
worksheet. Is there a way to make a design that you have created be
available within all of your worksheets? Through a template?

You can either make your own template, and always open it when you
plan to use a pivot table, or you should be able to save a standard
template so every time you click New it gives you a pre-formatted
blank workbook. In earlier versions of Excel, you'd save
"Book.xlt" (with your formatting changes, of course) to something like
this directory:
C:\ Documents and Settings\username\
Application Data\Microsoft\Excel\XLSTART

I would imagine there is a way to do this in xl2007. No doubt slightly
different, though. Should be able to find instructions in Help, search
for Default Template.