Thank you Debra

That worked fine.
It would go to the top of my "Wish List" for Excel 2007 to save any amended
Style Sheets so that they appeared automatically on opening a new workbook
instead of having to apply this workaround.
Thanks for your help, you have saved me a lot of grief and time.
Bob Spree


"Debra Dalgleish" wrote:

The styles are saved in the workbook, not in an external location.
You could copy a pivot table, that has a custom style, to another
workbook, and the custom style will be available in that workbook. Then,
delete the copied pivot table.

Bob Spree wrote:
H all
Excel 2007 PivotTables.
I amended a Style Sheet to the Company preferred Style.
Gave it a name, applied modifications, Set as default and all is OK.
When I open a new file and look for the Customised Style Sheet, it cannot be
found.
I thought the idea was that you could modify a Style Sheet and then use it
on future files.
Can anybody help.

Bob Spree


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html