Thanks in advance for reading. About six weeks ago, my Windows 10 machine underwent an update. Prior to that, on my Excel 2019 I had several shortcut buttons on the Quick Access Toolbar, each linked to macros in various workbooks stored locally on my machine. My workflow was designed to have the workbooks which hold the macros open, and I typically use each button at least once a day, often more. Each macro opens, manipulates, saves and closes several workbooks, each stored locally.
Ever since the aforementioned update, however, the computer has also been saving to OneDrive in addition to my hard drive. I am not sure why, I do not recall electing this configuration. The codes is the same, instructing the files to save locally, but they also seem to save to OneDrive at the same time (or perhaps saving locally triggers a save to the remote location). This saving to the internet slows down the processes, but not by so much that it’s unbearable. The real problem for me is that the macro buttons were modified in that the workbooks they reference were changed from the local versions to the OneDrive versions. So, when I click on one of the buttons, I get an error message saying that “Excel cannot open two workbooks with the same name at the same time.”
Before the update, the workbook was open because I was working on it, I’d click the button and it would call the macro and run as expected. Now, clicking on the button appears to try to open the workbook from OneDrive, even though it’s already open, causing the error.
I removed the new buttons, opened the local workbooks, and attempted to recreate the buttons, but the only options for macros to assign to the button were the OneDrive versions, with long http addresses rather than the local C: drive addresses. I realize that I can probably change the codes in the OneDrive files to close themselves after running such that they can be opened the next time I click the button, but If I need to work on the files then I have to open them back up again, just to close them to run the macros, defeating the purpose of the shortcut button.
Does anyone know how I can assign the local versions of the macro to the buttons? If I need to disable OneDrive entirely, that’s fine with me!
Thanks for your consideration.
Ever since the aforementioned update, however, the computer has also been saving to OneDrive in addition to my hard drive. I am not sure why, I do not recall electing this configuration. The codes is the same, instructing the files to save locally, but they also seem to save to OneDrive at the same time (or perhaps saving locally triggers a save to the remote location). This saving to the internet slows down the processes, but not by so much that it’s unbearable. The real problem for me is that the macro buttons were modified in that the workbooks they reference were changed from the local versions to the OneDrive versions. So, when I click on one of the buttons, I get an error message saying that “Excel cannot open two workbooks with the same name at the same time.”
Before the update, the workbook was open because I was working on it, I’d click the button and it would call the macro and run as expected. Now, clicking on the button appears to try to open the workbook from OneDrive, even though it’s already open, causing the error.
I removed the new buttons, opened the local workbooks, and attempted to recreate the buttons, but the only options for macros to assign to the button were the OneDrive versions, with long http addresses rather than the local C: drive addresses. I realize that I can probably change the codes in the OneDrive files to close themselves after running such that they can be opened the next time I click the button, but If I need to work on the files then I have to open them back up again, just to close them to run the macros, defeating the purpose of the shortcut button.
Does anyone know how I can assign the local versions of the macro to the buttons? If I need to disable OneDrive entirely, that’s fine with me!
Thanks for your consideration.