View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Adding information to a Pivot Table

Hi Bill

Not exactly sure what you mean here.
You cannot enter data directly onto a Pivot Table, you can only enter or
amend data in the source data table which upon Refresh will be reflected
in the PT itself.

Post back with a bit more detail and maybe we can help you.

--
Regards

Roger Govier


<Bill wrote in message
...
All,

I created a forecast pivot table that looks like:

Project owner Client Project Rule name % Used Backlog Type
Backlog Action Plan Progress Update Oct-2006 ($) Nov-2006 ($)
Dec-2006 ($) Total January February March April
Where I need to be able to make the January, February,
March.........columns accept input on the pivot table. When an
attempt is made to enter any data, the entire column assumes the same
value as the input value in a single cell. Is there any way to allow
separate data entry in each cell?

Thank you for your assistance.