I found some VBA code which would update all links in my PowerPoint. The objects are cells and charts in my password-protected Excel Workbook which is saved in the same folder on my laptop. The code works to update all links. However, whenever i open the PowerPoint and run the VBA, after updating all links, i would get a pop-up from Excel asking for password. The number of times varies. Subsequent runs of the VBA would not have this problem. It seems to occur for the first VBA run since opening the PowerPoint.

I tried checking the code, but i could not understand how this problem might occur. I tried accepting and cancelling the Excel Password Pop-up but was unable to discern if it affects the updating of links. I believe the code is fine as subsequent runs managed to accurately update links while the powerpoint is still open. The problem would occure when i close and re-open the powerpoint and run the VBA.