Custom UI Ribbon deleted when saved to onedrive

Hi,

I created a custom ribbon that is stored in a particular workbook. I used the Custom UI Editor for Microsoft office to create it using Andy Pope's Ribbon Editor. I have been using this ribbon for over a year now with no problems. I just recently moved to Office 365 and kept my workbook in Onedrive. I am not sure exactly what happened but, on reopening the workbook on my computer the custom ribbon has disappeared. The Excel xml also is not showing the custom UI ribbon.

Would really appreciate if anyone could help me with this since I have searching for an answer for days.

Regards,
Shashank

Hi Marvin,

Thank for your reply. Yes, I have kept the files on onedrive which can be accessed from different computers. I am ok with me not being able to use VBA on the cloud, however, my custom UI ribbon tab has been deleted. I am not sure why this is happening.

Regards,
Shashank

I don’t deny that VBA won’t work when accessing files online. However, the problem I am facing is not that the custom ribbon tab is disabled, but it is that it has been deleted. So now, even if I download the file and open it from the desktop app, I still can’t see the custom ribbon tab.

Regards,
Shashank

Hi AliGW

It is not an Addin... I used Andy Pope’s ribbon designer to build a custom tab in the ribbon. From what I understand, makes changes in the xml... but it is not even that other users are not able to access the custom ribbon. Even on my computer it has disappeared.

Thanks!

Hi Andy,

Thank you for your response. I am attaching two files - one with the custom ribbon tab titled "Analysis" and the other which was the same file but kept in my onedrive - as you can see, the custom tab has disappeared.

My Mac is running Excel 2016 whereas the desktop is running Office 365. My feeling is that the xml gets lost when I open the file kept in onedrive in the online version of excel through my office account, the custom ribbon tab disappears.

Really appreciate any help you can provide on this.

Cheers!
Shashank

PS - I had some trouble attaching the files but I think I finally was successful - I am new to excelforum. Let me know if for some reason you can't access them and I'll try uploading them again.

Originally Posted by AliGW

I am on Office 365.

I saved your file to OneDrive and then went to the browser interface, opened the file in the browser and then clicked on Open in Desktop App - the Analysis toolbar remains in place.

That's interesting. As you can see, it completely deleted the Analysis tab on my system.

Originally Posted by Andy Pope

I don't know what caused the removal of the customui parts, but whatever was responsible did so completely.
As well as the customui xml being removed the relationship reference was also removed.

Thanks for the try Andy. I guess there's nothing much I can do at my end now.

Shashank, this is definitely a OneDrive bug.
When you save the xlsm file to OneDrive and then download it back to your computer, the Excel Custom ribbon menu is lost.

It looks like the last update of OneDrive messed it up.
I'm trying to reach OneDrive's support but haven't been able to get in touch.

Thanks praddsouza! I have always felt this is a OneDrive problem since I have uninstalled OneDrive from my Mac and get the same problems.

I have been struggling with this for some time now and haven't found a solution yet.

Originally Posted by shashankgupta22

Thanks praddsouza! I have always felt this is a OneDrive problem since I have uninstalled OneDrive from my Mac and get the same problems.
I have been struggling with this for some time now and haven't found a solution yet.

You uninstalled OneDrive and you still have the issue or you don't?*

Some of my clients just experienced this issue and it's definitely OneDrive related. One user had the xlsm file open and someone else also opened it. The 2nd person's customui xml was completely removed.*

They are using the desktop version of excel on a PC. My hunch is it has something to do with OneDrives "Use Office applications to sync Office files that I open" setting. Cloud storage is great in a lot of ways but not having the ability to warn/prevent 2+ users from opening the same file can be an issue for files that shouldn't be used concurrently.*

I have posted a few findings related to other onedrive issues on the Microsoft answers site but not gotten any where and now have to add the xml ribbon stripping to the list.*

It would be great if Microsoft could get their office and OneDrive/SharePoint platforms to work together. I've lost business because xlsm files behave erratically when opened from onedrive on the user's desktop (not using the web version). Some VBA doesn't work at all and will prevent the file from saving. I don't have similar issues using other cloud providers like egnyte, dropbox, or box.

Still have the issues and have stopped using OneDrive for this purpose.