MSFT Excel pivot table links to external data
- by dreftymac
Question1: What is the best online forum to ask MSFT Excel questions of the following variety?
Question2: How can I link an excel pivot-table to a potentially changing source table without having to re-draw the excel pivot-table layout every time the source table changes data. (Note, the columns are not changing, just the data in the rows).
Background:
I have an excel 2007 pivot table that is grabbing data from another
sheet (an excel "table" ... tables are a new feature of excel 2007).
When I change the data in the source table, and then go to the pivot table and press "refresh" ... the pivot table reverts to its "blank" format and requires me to re-drag the columns rows and values.
What I want is for the pivot-table to simply re-draw itself without me having to re-create the pivot table layout.
