Refresh All pivots stops executing further code

Hi,

i am using sub like:

Please Login or Register  to view this content.

but msgbox part is not triggered. Somehow code is stopped on thisWorkbook.refreshall...

Can anybody help?

For power query i am using:

Please Login or Register  to view this content.

and it is working like a charm but i do not have option "Enable query in background".

Please help,
Jacek

Hi PaulM,

thanks!
This is not working.
The issue is when i am adding "Add this to data model". I do not know why...

Jacek

Ok i investigated and Data Model is not connected with the issue.
The problem is when i am creating pivot table from extarnal source. This is stopping code in RefreshAll statement...

Best,
Jacek

Hi Rory,

i wrote on the fly, sorry.

I found the issue here:

https://social.msdn.microsoft.com/Fo...rpivotforexcel

and here:

http://www.tomgleeson.ie/posts/20140...BARefresh.html

and here:

https://social.msdn.microsoft.com/Fo...rpivotforexcel

so this is very complex problem.
If you are passing dynamic parameter somethins is not working.
When you hit refresh all is working like a charm, but in VBA there is a bug.
Maybe i should report it somewhere to Microsoft?

I tried to Add to data model all tables and this code works:

Please Login or Register  to view this content.

What are prons and cons having table in Data Model? It will be harmful for performance?

Best,
Jacek