Default settings in Pivot-tables 2007

Prixton

Guest

Posts: n/a

1st Apr 2008

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

« Links Dialogue | Textbox linked to a cell (reposted) »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default Value Field Settings for Pivot Tables	mrobles	Microsoft Excel Misc	0	15th Jul 2009 02:33 PM
Value Field Settings for Pivot tables	Eden397	Microsoft Excel Worksheet Functions	0	24th Sep 2008 04:48 PM
Building pivot tables in Excel 2007 based on existing pivot tables?	jj.jigga.johns@gmail.com	Microsoft Excel Misc	4	26th Dec 2007 08:05 PM
Default Object Settings - Tables - Fixing Default Settings	=?Utf-8?B?Um9iZXJ0IFQu?=	Microsoft Powerpoint	4	2nd May 2005 04:13 PM
How can I change the default settings for pivot tables in Excel? .	=?Utf-8?B?S3lXaWxkZQ==?=	Microsoft Excel Misc	0	9th Mar 2005 11:33 PM