Forum Discussion
PERSONAL.XLB NOT WORKING ON 365
With excel 2010 and earlier versions I have created a custom toolbar that uses excel native commands and many many macros stored in personal.xlb. In the past when I bought a new computer I could expert and import the customized ribbon but that feature ignores the fact that your ribbon is calling out macros. So in the past I was able to just copy over the personal.xlb and relink the ribbon icons to the macros. But now having switched to 365 the nomenclature for personal.xlb has changed to personal.xlsb and therefore my .xlb file does not work even though it is sitting in the Excel start folder. I have tried renaming it to xlsb but that does not work. How can I get this to work so I don't have to go through the painful process of rewriting about 25 macros?
2 Replies
tomrdillon1944 , not sure if it would work but you could give it a try. I may have partial understanding of your issue given that i am not a 365 user and also am not an expert on working with ribbon customizations :-
1. Export the customized ribbon to a file.
2. Open the exported file with notepad or other text editor. It should show the xml data of the customizations with 'onAction' property for each button, something like onAction="C:\path\personal.xlb!Modulename.Macroname" .
3. Check that the "path" part of this property value is really the actual path where you have kept the .xlb file (START folder) or not. If not, then replace the incorrect path with the correct path. Do this for all button propertis in the file.
4. Save the ribbon customization file and import it.
amit_bhola Thanks. But I don't have a problem with the customized ribbon. It all looks good and each item connected to a macro show the path of the macro, etc. But when clicked on nothing happens.
