Refresh pivot table external data with encrypted password source file

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

As you are new I will add it for you Please read forum rules

https://www.mrexcel.com/forum/excel-...-password.html

I think I'm in the same situation, but it doesn't work for me. When I open the pivot file it does not refresh.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking

I moved your post to this existing thread