Forum Discussion
Solved
Duplicate Personal.xlsb workbooks
Hello there I have just bought a new computer on which Office 2019 is installed. To get the same macro functions I previously had, I copied my Personal.xlsb file to the correct XLSTART folder. Whe...
A mate has just helped me to fix the above issue.
The icons to my macros on my Quick Access Toolbar were somehow no longer linked to the Personal.xlsb workbook copied to my new computer.However, the macros in the copied Personal file were accessible from my new Excel programme (Office 2019).
Therefore, we simply deleted the old macro icons and linked each of my macros to new icons on my Quick Access Toolbar.Done. Fixed!
Hello Mark,
May I know the initial version of Excel you used to create the macro before you bought a new computer with Microsoft office 2019 version pre-installed?
May I know the initial version of Excel you used to create the macro before you bought a new computer with Microsoft office 2019 version pre-installed?
Certainly. I believe it was 2013 but it may have been as early as 2007 for some of the macros.
The 2016 Personal file worked without issue.