Saving an Excel file in a sharepoint synchronized local folder as PDF takes a long time to show up locally

Question

Hi there,

Hopefully someone can help me. I have the following situation:

1. Excel Files are on SharePoint Online
2. The SharePoint Online folders are synced locally
3. I open the Excel file from the local folder showing a path like: C:\Users\etc\temp.xls. In the file explorer it shows synced to SharePoint Online. So everything ok this far.
4. The file is set to autosave in Excel.
5. I like the file to be saved as pdf and select file save a copy
6. Then I see that the location is https://sharepointsite/library/folder etc. When I then save it, it is slow to sync back locally.

My questions:

1. Why does it go to the online folder and not to the local folder?
2. Is there a way to manipulate this?

Hopefully someone can answer my question. Thanks in advanced for your help, time and effort.

Regards,

Stefan

Answer 1

Hi @Stefan Verheggen,

Thanks for your detailed explanation, I am more than willing to help you out.

According to the information you provided and the research I have done, are you opening the excel file in the local sync folder and choosing to save as a copy, but the PDF copy is saved in the Online folder? Please correct me if something is wrong.

If there is not anything wrong, it is suggested that you please manually change to a local synchronization folder when you save as a copy. The default is to save to the Online location where the file was originally located.

If you have any questions, please do not hesitate to contact me.

Moreover, if the issue can be fixed successfully, please click "Accept Answer" so that we can better archive the case and the other community members who are suffering the same issue can benefit from it.

Your kind contribution is much appreciated.