In light of your comment above, I think the following may help you achieve your goals.
In order to develop Macros, you must first enable the Developer Tab in Excel. A macro will be created to save the excel file as a PDF. I'm going to assume that the excel file only has one worksheet. To save the macros with the file when you enable the macros and save it for the first time, you must save it as an xlsm file. After doing this, carry out the actions listed below.
-
In Onedrive create a new folder and call it "MyPubDocs" for example.
-
In Excel open up your online Xlsm file and do a SaveAs
-
In the file, dialog Box navigate to the Onedrive folder you created and take note of the folder name. It might show...
-
In Excel go to the developer Tab, if you don't see them go to File Menu -> Options -> Customize RIbbons -> Popular Commands (left) and Main Tabs (right) and check the Developer checkbox. click OK.
-
Click on Macro Button Set the Macro name to "SaveToOneDrive" ad click create.
-
That should open an IDE where you will paste the following command.
ActiveWorkbook.SaveAs Filename:="https://d.docs.live.net/XXXXXXXXXXXXXX/MyPubDocs/" & "MyExcelFileExportAsPDF.Pdf"
-
When creating the macro you should be able to assign a hotkey to that macro.
-
Now, whenever the admin finishes saving the excel file, they can press the hotkey or run the macro and it will save the file to the location.
-
If you want to associate the macro to the save event of the workbook, you can, but auto-save should be turned off.
-
After the first time, you saved the pdf, go to onedirve and navigate to the pdf file. Create a shareable link that you can distribute to your users. When they navigate to that sharable link it should show them the most recent pdf.
