Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i need to insert a row with the date into a pivot table. any ideas? please
help! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Give us more information.
If you simply want to print the date on the same page as the Pivot table, use Page Setup. Another option is to enter the date in the column adjacent to the Pivot table. Otherwise, tell us why you would want to insert a row in a Pivot table. -- Regards, Fred "Deanna" wrote in message ... i need to insert a row with the date into a pivot table. any ideas? please help! |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am sorry, I meant data. I need to insert a row in the pivot table and am
unable to do so... thanks!!! "Fred Smith" wrote: Give us more information. If you simply want to print the date on the same page as the Pivot table, use Page Setup. Another option is to enter the date in the column adjacent to the Pivot table. Otherwise, tell us why you would want to insert a row in a Pivot table. -- Regards, Fred "Deanna" wrote in message ... i need to insert a row with the date into a pivot table. any ideas? please help! |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
But why isn't the data in the source table? Isn't that the best place for it?
You still haven't given us any idea of what data you want to insert, where in the table, etc. If you want a brute force solution, copy the pivot table, and paste special values. Now you can modify the table to your heart's content. -- Regards, Fred "Deanna" wrote in message ... I am sorry, I meant data. I need to insert a row in the pivot table and am unable to do so... thanks!!! "Fred Smith" wrote: Give us more information. If you simply want to print the date on the same page as the Pivot table, use Page Setup. Another option is to enter the date in the column adjacent to the Pivot table. Otherwise, tell us why you would want to insert a row in a Pivot table. -- Regards, Fred "Deanna" wrote in message ... i need to insert a row with the date into a pivot table. any ideas? please help! |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks a lot - I'll try it at work on Tuesday.
"Fred Smith" wrote: But why isn't the data in the source table? Isn't that the best place for it? You still haven't given us any idea of what data you want to insert, where in the table, etc. If you want a brute force solution, copy the pivot table, and paste special values. Now you can modify the table to your heart's content. -- Regards, Fred "Deanna" wrote in message ... I am sorry, I meant data. I need to insert a row in the pivot table and am unable to do so... thanks!!! "Fred Smith" wrote: Give us more information. If you simply want to print the date on the same page as the Pivot table, use Page Setup. Another option is to enter the date in the column adjacent to the Pivot table. Otherwise, tell us why you would want to insert a row in a Pivot table. -- Regards, Fred "Deanna" wrote in message ... i need to insert a row with the date into a pivot table. any ideas? please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert formula in a pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE HOW TO INSERT....... | Excel Discussion (Misc queries) | |||
Pivot Table Refresh - Auto insert row | Excel Discussion (Misc queries) | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Insert column in Pivot Table | Excel Worksheet Functions |