Powerpoint 365 automatically closes linked Excel-files
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
|