Debug of pivot tables

Hi Raf,

Thanks for the question.

I am in the office tomorrow so I will go through the code and find out why the code was not executing a new sheet and pivot table for existing tabs.

Regards

Simon

Hi Raf,

I have looked at the code and amended the following:

1. I uncommented the Call Delete sheet line of code in the CreateSheet procedure.

2. In the MainSPReport there was no line of code calling the PivotAnalysis so I added it in.

If you are using the command button, you need to comment out the Call PivotAnalysis as we have the blnPivot = true then call PivotAnalysis.

Please find the amended code attached.

I hope this answers your question.

Regards

Simon