Hi,

I have one Powerpoint presentation which is linked to several Excel-files which update the PPT-file. To update the Powerpoint file I used to open the linked Excel-files before I opened the PPT-file and then opened the PPT and clicked "update links". That all worked fine.

However, at work, we recently transferred to Onedrive/Sharepoint directories and since then PPT automatically closes the Excel files when I open PPT and click "update links". This wouldn't be too bad - updating just takes a little bit longer than it used to - but there is one Excel file which has password protection and the "Enter Password" window keeps opening up twenty times.

Is there a way to keep all linked files open while updating PPT?

Any help pointing me in the right direction is appreciated, thanks.



Regards,
Roland