Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Default settings in Pivot-tables 2007

Hi,
We use Excel 2007 and in using the Pivot-tables we have come to a problem:

In the Field Settings we always have to change the Subtotals from Automatic
to None. Is there a way to change the default settings so we do not have to
make this change every time manually?

Thanks for every hint


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
pivot default settings Flagus Excel Discussion (Misc queries) 0 June 5th 06 12:33 AM
Pivot Table Field Settings Default value MMesarch Excel Discussion (Misc queries) 2 November 2nd 05 09:50 PM
Default Value to Zero in Pivot Tables Cheryl B. Excel Worksheet Functions 1 August 5th 05 05:30 PM
How can I change the default settings for pivot tables in Excel? . KyWilde Excel Discussion (Misc queries) 0 March 9th 05 11:33 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"