Share via

Transferring macros from older Excel to new Excel running under Windows 11

Péter Szabó 0 Reputation points
2025-02-08T09:26:52.0066667+00:00

I created custom number formats in Excel on my Windows 10 machine. (kg, fm, m3, etc......) I placed these with small icons on the ribbon. I bought a new machine running Windows 11. I was able to import the ribbon items into Excel on the new machine. However, when I click on them, it gives me an error message, a command line, saying that it cannot find the file named "personal.XLSB". I copied the file named "personal.XLB" from the previous Windows 10, but the Windows 11 file system is completely different so there is nowhere to copy it. The file system structure is also completely different. What can I do?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,279 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,765 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Péter Szabó 0 Reputation points
    2025-02-09T07:27:15.02+00:00

    I want to avoid having to recreate them. That's why I want to import them from the old one.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.