QAT icons have all disappeared from my Excel 365 workbooks

[PD in Waterloo]

Hi all ... I searched for this topic but didn't find anything that was relevant to my issue. So here goes: I just opened a workbook I've been using for a few months, and to my chagrin, my Quick Access Toolbar (QAT) seems to have self-reset to having only the AutoSave slider button and the Undo/Redo icons. This workbook (and all my workbooks) had about 40 icons on the QAT, from all the different tabs. Now there's nothing. This situation is also true of all the other workbooks I have, whether stored on OneDrive or stored only on a local drive. Some workbooks are saves as .xlsb and most as .xlsx, but all are affected the same. I've seen a suggestion that I go to File > Options > QAT > Reset, and use the pulldown to select "Reset only QAT," but that option is greyed out. I added the Copy icon to a workbook, and it stuck, but it didn't persist; when I closed and re-opened the workbook, the added icon was no longer on the QAT, which had reverted to just the same AutoSave, Undo, and Redo as before.

I just opened the same workbook on a different computer, and the QAT is fine, just as I left it earlier, with all my icons on the QAT and functional. The second computer got the file from OneDrive. But when I open the file on both computers, the second computer keeps the QAT icons, the first computer opens the file and the icons are not on the QAT. I checked a few personal templates I have, and the QATs on them are also all similarly devoid of my icons on the first computer but have all the icons on the second.

I think there's a possibility that this has something to do with some recent software updates to Office 365 (my second computer doesn't get them as fast as my first), but that's nowhere near certain. Al;so, other Office applications still have their icons on QAT as normal.

Any info gratefully recieved. Thanks, everybody!

PS

One other question... If I were to export the Excel QAT settings on my second (working) computer to a USB drive and then import them to the Excel on my first computer, might hthat fix the issue?

 

[6StringJazzer]

The QAT configuration is not stored in any Excel file. The file and its location don't matter. What matters is what machine you open Excel on. All of the files on the same machine are going to show the same QAT. (What do you mean by "from all the different tabs."? The QAT does not have tabs.)

Open the Excel file on the other machine where that QAT is what you want. Right click on any QAT button and select Customize Quick Access Toolbar. In the window that opens, in the lower right corner select Import/Export and then Export all customizations. (This will also include any Ribbon customizations.) If both computers have access to OneDrive you can export the file to a OneDrive folder.

Go back to the other computer and do the process in reverse--import the file you just saved.

This will make all QAT and Ribbon customizations on the latter computer the same as the former.

If the wording is not clear let me know and I'll add screen shots.

 

[6StringJazzer]

One other question... If I were to export the Excel QAT settings on my second (working) computer to a USB drive and then import them to the Excel on my first computer, might hthat fix the issue?

I missed your last line. Yes, that should fix it. You could use a USB drive but probably easier to use OneDrive as I mentioned.

 

[PD in Waterloo]

Hey 6-string... Thanks for the info. I followed your instructions, using OneDrive. Worked like a charm! Thanks so much.

PD

On an unrelated note, I like jazz guitar (and classical, for that matter), but I don't hear much on acoustic. Any recommendations?