VBA doesn't refresh Pivot Table

[TheHack22]

Hi VBA Experts,'

I have this simple VBA to refresh a single Pivot Table in a file, but it doesn't work.
This is a small part of many steps in my process. The PVT Data doesn't refresh and thus, this throws out the other steps.

Sub Workbook_RefreshAll()
Sheets("PVT").Activate
ActiveSheet.Range("C6").Select
ActiveWorkbook.RefreshAll
End Sub

Can someone say why this wouldn't work?
Imran

 

[BSALV]

at the moment, this macro runs, is the activeworkbook the workbook you want ?
Are you sure this macro is called ?

 

[Alex Blakenburg]

In addition to BSALV's questions, is the pivot data range dynamic as in using a table range and picking any additional rows ?
And another possibility, is the pivot based on a Power Query Table ?

 

[TheHack22]

at the moment, this macro runs, is the activeworkbook the workbook you want ?
Are you sure this macro is called ?

Hi @BSALV

Thanks for your response. Yes, the workbook is the Activework, which becomes active with the preceding Sub.
Yes to the second question too.
Imran

 

[TheHack22]

In addition to BSALV's questions, is the pivot data range dynamic as in using a table range and picking any additional rows ?
And another possibility, is the pivot based on a Power Query Table ?

@Alex Blakenburg

Thanks for your question.
I just realized that my data source is not dynamic (Not in a Table Format).
There is no Power Query in this process.

Imran

 

[Alex Blakenburg]

I just realized that my data source is not dynamic (Not in a Table Format).

Are you able to use a table and then use the table name as the data source ? and does that fix your issue ?

Note: Please give the Table a meaningful name and not just Table1. I tend to prefix my table names with "tbl" that way the tables group together in the name manager and if you start typing =tbl in the formula bar you get a list of your tables.

 

[TheHack22]

Are you able to use a table and then use the table name as the data source ? and does that fix your issue ?

Note: Please give the Table a meaningful name and not just Table1. I tend to prefix my table names with "tbl" that way the tables group together in the name manager and if you start typing =tbl in the formula bar you get a list of your tables.

@Alex Blakenburg
Thanks very much for this tip. I formatted the data source as a table and that solved the issue.
Imran

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.