MSFT Excel pivot table links to external data
Posted
by dreftymac
on Super User
See other posts from Super User
or by dreftymac
Published on 2009-08-17T16:34:31Z
Indexed on
2010/06/09
18:42 UTC
Read the original article
Hit count: 529
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.
© Super User or respective owner