N
Natalie 1229
1. Do you HAVE to move colums/fileds around in your base table (the ra
data) in order to alphabetize Pivot Table Field List or is there som
other way to do it?
Other PivotTable Questions:
2. How do I find the original datasource of a pivot chart? Dat
3. In the same Book (Excel), can I have two different sheets tha
use/reference data from different external sources? Or am I limited t
one data source per Excel workbook?
4. If I copy and paste a pivot table from one workbook to another, wil
it reference the same data? What if I copy and paste a pivot table fro
one spreadsheet to another (assuming my question #3 is possible)?
5. Do I have to refresh every Pivot Table on the same sheet
individually if I've updated the data?
Thank you, thank you, thank you!
Natalie:
data) in order to alphabetize Pivot Table Field List or is there som
other way to do it?
Other PivotTable Questions:
2. How do I find the original datasource of a pivot chart? Dat
columns in your query. I can’t find the original table.
3. In the same Book (Excel), can I have two different sheets tha
use/reference data from different external sources? Or am I limited t
one data source per Excel workbook?
4. If I copy and paste a pivot table from one workbook to another, wil
it reference the same data? What if I copy and paste a pivot table fro
one spreadsheet to another (assuming my question #3 is possible)?
5. Do I have to refresh every Pivot Table on the same sheet
individually if I've updated the data?
Thank you, thank you, thank you!
Natalie: