none
Excel Ribbon buttons wont function after importing RRS feed

  • General discussion

  •  If you ever encounter any error when trying to use your newly imported excel2016 ribbons for the first time, here is a work around;

    Take note of the path displayed in the error message, for example assume your name is john;

    "Cannot run the macro "C\Users\john\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB'!Clear_All_Formats'. The macro may not be available in this workbook or all macros may be disabled.

    Notice that the path for the macro file is

    C\Users\john\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB

    You are getting an error because your user directory is not john.

    You could manually create a folder name "john" and add it inside the "Users" parent folder.

    Now manually add the rest of folders for AppData, Roaming, Microsoft, Excel, and XLSTART

    Place your macro file inside the XLSTART folder.

    Right click on the "john" directory and choose "Give Access To"

    Remove any current restriction so it is available to share the macro file.

    Your error should stop now.

    Another way is to create a new user by the name of john.

    Sunday, April 1, 2018 2:22 AM