Hello everyone,

I use the following formula to pull data out of a protected file;

Please Login or Register  to view this content.
I notice that, when data is changed in the protected file, the data in my file isn't updated.

I made some test files and i think that's because the file is protected.

I got the password of the protected file. How can I add this to the formula (or with VBA) to make sure my data is updated when the data in the protected file is changed?

Thanks in advance