We are using Office 365. I have an excel file in SharePoint in this Office 365 environment.

1. Excel File is a macro enabled file with XLSM extension.
2. File has multiple Sheets in it.
3. Multiple user simultaneously edit this file and Excel Auto Save is enabled on this file, which saves the file every minute.

I'd like to save this file as XLSX file to another network folder when a user clicks the save button but NOT excel auto saves.

Can someone please provide a macro to accomplish this? I currently have a macro but this macro runs even when excel autosaves and it takes a long time to make a copy and causes performance issues.

Thanks in advance,

Nick.