I create a Pivot Table and use external connection to connect the data.
The data is a shared excel file (office 2010) with password protected. I have the password.
When I connect the PT to the protected data, it pop up for a password request. I input the correct password but cannot connect.
Something doing wrong?
Pls kindly advise. Thanks.
The data is a shared excel file (office 2010) with password protected. I have the password.
When I connect the PT to the protected data, it pop up for a password request. I input the correct password but cannot connect.
Something doing wrong?
Pls kindly advise. Thanks.