JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,687
- Office Version
- 365
- Platform
- Windows
I just bought a new Win 11 laptop and am working a bit frantically to get everything moved over before we leave in a few days for a month. I was making good progress until I decided to fiddle around with my OneDrive Personal Vault. I should know by now that I should never try anything new from M$FT if I have less than a month to work out all of the little gotchas.
Shortly after my fiddling, my laptop started to freeze for anywhere from 5-10 minutes to several hours. Then I noticed a little red X (actually a white X in a red circle) on the OneDrive folder. Like this:
I also noticed the little character next to the checked circle in the status column.
If I expand that folder, I see that the X is on the Personal Vault. If I double-click on the Personal Vault, it goes through its two-step authentication to show me an empty folder.
I then opened a workbook I have been working on for several months. It has a Button control that calls a macro in my add-in module. When I clicked on it, I got a message about not being able to connect to "d.docs.live.net". I have no idea what that is. After some fiddling around, I discovered that the workbook that I thought was on C-disk, was actually on the OneDrive folder in the cloud. I have no idea how it got there or why it was loaded rather than the one on my C-disk, which is still there.
Then I discovered that the macro that the button control was assigned to was also on the OneDrive folder. This is the macro assignment string:
That macro is also in my add-in on my C-disk, but I cannot figure out how to change the macro assignment back. I have tried every combination of text strings I can think of, including:
Shortly after my fiddling, my laptop started to freeze for anywhere from 5-10 minutes to several hours. Then I noticed a little red X (actually a white X in a red circle) on the OneDrive folder. Like this:
I also noticed the little character next to the checked circle in the status column.
If I expand that folder, I see that the X is on the Personal Vault. If I double-click on the Personal Vault, it goes through its two-step authentication to show me an empty folder.
I then opened a workbook I have been working on for several months. It has a Button control that calls a macro in my add-in module. When I clicked on it, I got a message about not being able to connect to "d.docs.live.net". I have no idea what that is. After some fiddling around, I discovered that the workbook that I thought was on C-disk, was actually on the OneDrive folder in the cloud. I have no idea how it got there or why it was loaded rather than the one on my C-disk, which is still there.
Then I discovered that the macro that the button control was assigned to was also on the OneDrive folder. This is the macro assignment string:
That macro is also in my add-in on my C-disk, but I cannot figure out how to change the macro assignment back. I have tried every combination of text strings I can think of, including:
- 'C:\Users\Me\AppData\Roaming\Microsoft\AddIns\My Add-Ins\WtdRtg'
- 'Remote Access Software.xlsx'!'C:\Users\Me\AppData\Roaming\Microsoft\AddIns\My Add-Ins\WtdRtg'
- 'Remote Access Software.xlsx!C:\Users\Me\AppData\Roaming\Microsoft\AddIns\My Add-Ins\WtdRtg'
- What am I doing wrong?
- How can I fix this in every other workbook, of which I have hundreds?
