Inserting a new Column in Pivot Table

[NM123]

Hi,
I want to add a new column in the pivot table which has been system generated. I tried manually to enter a new column, but its not happenning. I attached the sample sheet generated by system. I want to add a New Column in the 1st sheet(Traceability Matrix) after the "Source Requirements" column(Row-8).

Please do let me know if it can be done through Macro.

Regards,
NM

[Aflatoon]

No it cannot, unless you convert the pivot table to a static range first (which you can also do manually). You can either add the column to the left of the pivot table, or add a new column to the underlying data source.

[NM123]

Hi,
Thanks for your time. I just wanted to know about your comment on
" unless you convert the pivot table to a static range first (which you can also do manually). "

Can you please explain a bit on this.

Regards,
NM

[Aflatoon]

I simply mean that you would have to copy the table and Paste Special - Values (so it would no longer be a pivot table)