Hi I am trying to set the connection of a pivot table to an ADO connection as a work around for accessing password protected excel files. Currently I have code to change all pivot tables to a different connection. I want to be able to set the connection to an ADO connection instead so my pivot tables can access data from a password protected file. How do I do this????
Solved by I. S. in 14 mins