Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-21-2025, 11:20 AM
MartinGM MartinGM is offline Ribbon and OneDrive causing problems Windows 11 Ribbon and OneDrive causing problems Office 2021
Competent Performer
Ribbon and OneDrive causing problems
 
Join Date: May 2023
Location: England
Posts: 108
MartinGM is on a distinguished road
Default Ribbon and OneDrive causing problems

This is a bit of an oddball, but hopefully someone may have some insights, or a workaround ?
I have a complex Excel 365 workbook which is backed up to OneDrive. To allow me to have easy access to a large number of macros, I have created a Ribbon group full of labelled shortcuts to the macros I need.
That works very well, or at least it did until yesterday . . . whenever I now click on one of the shortcuts there s a long pause than a message "You cannot have two workbooks with the same name open at the same time"
I have found out the cause - my internet connection had temporarily failed and I had been, without my knowledge, directed to the local copy instead of the copy in the cloud. Everything still worked (as it should) except ribbon items which I now know are specific to the file location - I had set up the ribbon when connected to the cloud and none of the shortcuts worked when connected to the local copy.
When OneDrive makes the otherwise seamless switch from cloud to local my custom Ribbon group no longer functions.
This is going to be a pain when I am travelling.
I thought I could get around this by having Excel always open my file from the local copy but I cannot find out how to do that.
I even created a shortcut to open the file - pointed at the local copy - but when the cloud is connected it seems automatically to open the cloud copy.


Help !

Last edited by MartinGM; 08-21-2025 at 02:28 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with Excel VBA and OneDrive MartinGM Excel 2 01-26-2025 03:59 PM
Update Causing Clipboard Problems msdoncow Word 0 02-08-2022 08:38 PM
How to import the customized ribbon to Word without overwriting the existing Ribbon? SharonSh Word VBA 0 09-26-2013 11:47 PM
Ribbon and OneDrive causing problems Importing Styles causing odd formatting problems. Red Pill Word 3 06-12-2012 06:19 AM
Excel 2010 Ribbon look like 2007's Ribbon esotop Excel 0 03-22-2011 07:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft