If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro delay while saving to OneDrive - Excel 2013, Win 8.1

Thread starter Yamezz
Start date Jun 27, 2015
Tags

onedrive

Yamezz

Active Member

Jun 27, 2015

I have macro that creates an invoice from a job card entry, prints the invoice, clears the job card for the next job and saves the file. This macro was working fine with XP and Excel 2007, but a recent 'upgrade' to Win 8.1 and Excel 2013 has resulted in a lengthy delay to the macro, while it waits for the saved file to be uploaded to OneDrive. What could be causing this and what's the solution? I have tested with Excel 2010 running on Win 7 with OneDrive and don't have this problem. The file saves to the hard drive then backs up in the background, without causing a delay to Excel.

Thanks.