I have an existing Worksheet that consists of fields and data. This
worksheet is used for a Pivot Table. My Pivot Table is formatted as a
report. I would like to keep the pivot table format and just change the
data. How do I do this without messing up the pivot table format? Please
help. Any help will be greatly appreciated. Thank you.

If I understand what you are trying to do all you would need to do is change
the data in your data worksheet and refresh the pivot table.

If you want to change the field headers in your data worksheet you will need
to go back into the pivot table layout and refresh the range where the table
gets the data after you changed the headers. That should then refresh the
pivot table layout and data.

Hope this helps


"TotallyConfused" wrote:

I have an existing Worksheet that consists of fields and data. This
worksheet is used for a Pivot Table. My Pivot Table is formatted as a
report. I would like to keep the pivot table format and just change the
data. How do I do this without messing up the pivot table format? Please
help. Any help will be greatly appreciated. Thank you.

Thank you.

"MarkM" wrote:

If I understand what you are trying to do all you would need to do is change
the data in your data worksheet and refresh the pivot table.

If you want to change the field headers in your data worksheet you will need
to go back into the pivot table layout and refresh the range where the table
gets the data after you changed the headers. That should then refresh the
pivot table layout and data.

Hope this helps


"TotallyConfused" wrote:

I have an existing Worksheet that consists of fields and data. This
worksheet is used for a Pivot Table. My Pivot Table is formatted as a
report. I would like to keep the pivot table format and just change the
data. How do I do this without messing up the pivot table format? Please
help. Any help will be greatly appreciated. Thank you.