Error 1004 on Macro to refresh pivot tables

Hello,

I have occurred a problem with my macros.

I have a document that contains 5 worksheets.

Worksheet1 is a data, which is used for three different pivot tables each located in different worksheet.

Worksheet 1 – Daily movements
Worksheet 2 – Balance by Part (StockByPart - Pivot table)
Worksheet 3 – Balance by SubCons (StockBySubCon – pivot table)
Worksheet 4 – Outstanding and Arrears (Balance – pivot table)
Worksheet 5 – Sheet3

This is my latest amendment to the first macro:

Please Login or Register  to view this content.

Previous to that I had:

Please Login or Register  to view this content.

But my first macro was:

Please Login or Register  to view this content.

I do not understand why from the very beginning I cannot overcome the “Run-time error 1004. Unable to get the Pivot Tables property of the Worksheet class”

If need be I will upload the workbook to have a look unless someone ca spot the mistake I have made in the first place.

Thanks for reading this.

Simon

I just cannot make it work.

I am attaching two files. One with pivot tables in separate sheets and the other with all tables on one spreadsheet. All on one spreadsheet has become error9 now.

I don't know what else I can do to make it run.

If anyone could test it and see if it works for him it would be great. At least to know if in general it works and it is something with my pc or I made it all wrong.

Thanks for reading it and giving it a go.

Simon

Thank you rylo,

you werer right in both cases. I do not understand how it happened the it changed that style of "" the apostrophes.

works perfect now.

Thank you.
Simon