LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 07, 12:19 AM posted to microsoft.public.excel.misc
Maz Maz is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2007
Posts: 9
Default Pivot Table Groups by Date

I am using multiple pivot tables in Excel. They are separate tables based
upon the same data; but let me stress they are not Pivot Tables based upon
each other.

When I attempt to change the data from weekly summaries to daily in one
table it changes all the other tables to the daily. I read a post from
5/17/2007 on this and it indicated the pivot tables needed to be based upon
the data not upon each other - mine ARE based upon the data and not upon each
other. It's as though they were linked in some other way. So this post was
of no use to me or made assumptions that were specious.

Can you tell me how to de-link pivot tables so I can show different date
groupings in tables on different worksheet pages?

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
pivot table to contains more than 1 field groups jackysoh Excel Worksheet Functions 0 September 28th 07 04:34 AM
Pivot Table groups & cumulative totals laureleaw Excel Discussion (Misc queries) 0 April 26th 06 08:53 PM
Pivot Table Groups Chris Excel Worksheet Functions 2 February 24th 06 06:42 AM
Pivot Table Date Groups MarkN Excel Discussion (Misc queries) 2 February 16th 06 12:39 AM
pivot table and groups tysop Excel Worksheet Functions 1 January 24th 06 06:33 PM

All times are GMT +1. The time now is 08:02 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017