ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table moving information (https://www.excelbanter.com/excel-discussion-misc-queries/240563-pivot-table-moving-information.html)

RK WV

Pivot Table moving information
 
I am having problems creating a pivot table to which the table carries over
the format out of the original document. I will open my Pivot Table then
click one of the total numbers it will bring me to the list, but on that
sheet the formulas of the orignal document our not there. Is this just a
fault in Pivot Table? Or can I make the orignal formulas copy over?
--
RK

smartin

Pivot Table moving information
 
RK WV wrote:
I am having problems creating a pivot table to which the table carries over
the format out of the original document. I will open my Pivot Table then
click one of the total numbers it will bring me to the list, but on that
sheet the formulas of the orignal document our not there. Is this just a
fault in Pivot Table? Or can I make the orignal formulas copy over?


No, that is the way pivot tables are designed to work. Pivot tables do
not store information about formulas or formatting you might have in the
original data, only the values.


All times are GMT +1. The time now is 05:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com