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: 494

Filed under:
|
|
|
|

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

Related posts about excel

Related posts about excel-2007