Be sure to review our Idea Submission Guidelines for more information!
Submission GuidelinesI believe many have voiced out this as their pain point within the Community. Essentially, there is no straightforward method to import multiple Excel files which are password protected.
I understand that there is an R solution suggested by several users, however, that is not ideal as it can be difficult to obtain permission from internal Tech team to install the package on the users' computers.
Re-saving them without password is not only a hassle, but also raises concerns for data protection and security.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.