This really frustrated and confused me, because I had never seen this problem before until, I think, I started using Excel Professional 2016. However, when I recently placed these files on my laptop at home and tried to run macros from custom macro buttons in my QAT file, I was getting an error message of " Sorry, Excel cannot open two files with the same name at the same time" (or something very similar). Thanks SO much for the info you shared! As I have changed jobs, I have moved around to several new computers, and I have always moved copies of my macro files, which are usually located at C:\Users\\AppData\Roaming\Microsoft\Excel\XLSTART\, and my Excel User Interface file (which contains the info for the QAT (Quick Access Toolbar) and any custom macro buttons I have inserted in the QAT), Excel.officeUI, usually located at C:\Users\\AppData\Local\Microsoft\Office\, to my new computer, so I don't lose all my macros or the work I spent setting up custom macro buttons on the QAT. I hope someone has dealt with this problem successfully in the past Appreciate any suggestions. Those don't work either.Ĭustomizing built-in commands works just fine, existing ones and any new ones added. So it's isolated to just one workstation.Īlso, I tried to create a custom ribbon tab, and add macros there.
Then I tried to import the same file on another machine, and it worked there. I exported the toolbar, and examined the XML - appears fine. No new (or old) macros added to the QAT run. I have tried removing and re-adding the buttons, and resetting the toolbar - doesn't work. The macros still work just fine, and in the Customize menu it says the correct path and name for each one. I have a large number of macros, stored in PERSONAL.XLSB, that I have assigned over time to buttons on my quick access toolbar (QAT). Now I am experiencing this issue and it's driving me crazy.
I've seen this asked before around the Internet, but did not see any good answers. Excel 2010, Office Pro Plus, Windows 7, everything 32 bit.
0 kommentar(er)
