| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add extra data to a pivot table?
I know this might sound slightly simplistic, but my pivot table pulls data
from a separate tab. I know if I go in and amend the data in that table and then save and restart, the data in my pivot table will change accordingly. What I cannot figure out is how to add extra rows that will be reflected in the pivot table. I can't find anyway to expand the data field in pivot table options. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add extra data to a pivot table?
EXCEL 2007
Click in the Pivot Table to launch the PivotTable Tools on the right hand side of the Title Bar (highlighted in red). Options / Data group / Change Data Source - this will highlight the data for your existing Pivot Table / now extend the range as required and hit OK. If my comments have helped please hit Yes. Thanks. "Max" wrote: I know this might sound slightly simplistic, but my pivot table pulls data from a separate tab. I know if I go in and amend the data in that table and then save and restart, the data in my pivot table will change accordingly. What I cannot figure out is how to add extra rows that will be reflected in the pivot table. I can't find anyway to expand the data field in pivot table options. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I add extra data to a pivot table?
That's perfect, thanks for the help. Much appreciated.
"trip_to_tokyo" wrote: EXCEL 2007 Click in the Pivot Table to launch the PivotTable Tools on the right hand side of the Title Bar (highlighted in red). Options / Data group / Change Data Source - this will highlight the data for your existing Pivot Table / now extend the range as required and hit OK. If my comments have helped please hit Yes. Thanks. "Max" wrote: I know this might sound slightly simplistic, but my pivot table pulls data from a separate tab. I know if I go in and amend the data in that table and then save and restart, the data in my pivot table will change accordingly. What I cannot figure out is how to add extra rows that will be reflected in the pivot table. I can't find anyway to expand the data field in pivot table options. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extra data for pivot table | Excel Discussion (Misc queries) | |||
| Expanding a data table to include an extra row | Excel Discussion (Misc queries) | |||
| How do I change my data or add extra rows in a Pivot Table for Ex. | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How to pull extra info into Pivot table report | Excel Worksheet Functions | |||
Linear Mode
