Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,049
Default Pivot Tables - delete rows from Master List

pivot reports are a view if you will, on the underlying master table.
so yes, you are correct.
however, double clicking one of the pivots extracts the raw data which isn't
dependent on the master table

"mathel" wrote in message
...
I have a workbook with 3 worksheets. One is a Master list, and the other
2
are Pivot Tables (called Under 10k & Over 10k).

Once I have done the Pivot report, I no longer need the data in the rows
from the Master list. However, I find that if I delete the rows, the
Pivot
Table is reverting to 1 line with no data.

Am I assuming correctly that no data should be eliminated from the Master
List in order that the Pivot Tables filter properly?
--
Linda


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
create 1 master list from a combination of rows and columns Jason Excel Discussion (Misc queries) 3 August 17th 09 06:24 PM
Pivot tables - edit pivot table and updating master data MikeSA Excel Programming 2 June 4th 09 12:03 PM
How can I delete rows from Pivot Tables in Excel 2000 as in 97 Rex at B$4U Excel Discussion (Misc queries) 0 April 18th 05 04:55 AM
updating data in rows from master list Allen Nance Excel Programming 7 September 18th 03 06:18 PM
updating data in rows from master list Allen[_8_] Excel Programming 0 September 17th 03 09:42 PM


All times are GMT +1. The time now is 04:10 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"