Pivot Error showing but on a different macro Sheet. Not on the sheet the where I refreshed

[Devonair]

Hi,

This is my first time. I have been looking everywhere for a solution for this
I have made a pivot table on Sheet4 and named the Pivot table to Overtime.
But when I refresh manually by right click the newly made pivot table stops and shows an error

------------------
Run-time Error '1004':

Unable to get the PivotTables property of the Worksheet Class
------------------

When I click Debug the error goes to my sheet3 Not in sheet4 and points to this different Pivot table I made previously

Sub RefreshCustomPivotTable2()
Application.DisplayAlerts = False
With ActiveSheet
.PivotTables("WBS_Pivot").RefreshTable <- this one has the error pointed at
End With
End Sub

Its not the pivot table I refreshed, and not even at the same sheet.

Can anybody help me on this issue. I am using Excel 2013 by the way.

Lots of thanks guys

 

[Michael M]

post the link back here

 

[Devonair]

post the link back here

here

https://www.dropbox.com/s/s3mnhxxew52huos/pivotproblem.xlsm?dl=0

Thanks again for your big help, appreciate it very much

 

[Michael M]

The Pivottable on Sheet 4 is called Pivottable1.
I can't find a pivot table called WBS_Pivot !!!

 

[Devonair]

The Pivottable on Sheet 4 is called Pivottable1.
I can't find a pivot table called WBS_Pivot !!!

the WBS_Pivot is in Sheet3, name Report 02 at the tab of the workbook.


Thanks for you help and concern, after trying to find the solution I think I stumble on the answer.
after creating the 3rd pivot table. It automatically shares pivot catche with the 2nd. I still don't know much about it
but it seems it auto links itself to the 2nd pivot table, he suggested to use Alt + D and P instead of making another Pivot table from the tool bar directly.

Its weird why would excel do that.