I already have Smart view connection in a excel file but when I am creating a new sheet in that same excel file I have to go to Smart view pannel and click on connection option and then on the required connection and then that sheet gets connected to the smart view. I am trying to automate where I can use VBA and that given sheet will get connected to the smart view connection. Please let me if this possible?