| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a row in a pivot table | Excel Discussion (Misc queries) | |||
| Using the information from a pivot table | Excel Worksheet Functions | |||
| Moving an Excel pivot table to access | Excel Worksheet Functions | |||
| Extracting Information from A Pivot Table | Excel Discussion (Misc queries) | |||
| Moving excel data into a pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
