If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table-Change Data Source? Excel 2007
I need to update a series of pivot tables by adding 2010 data. What's the
best way to do so? Add the updated info to the source document and refresh, or create a new data source and refresh all the tables? Does the new source have to have the columns in the same order as the previous? If I create a new source document, how do I tell the tables to change the source? Other responses to this question say to rightclick a cell and use the wizard. I'm using Excel2007 and right clicking doesn't produce a wizard. Thanks |
Thread Tools | |
Display Modes | |
|
|