Forum Discussion
dapper49
Mar 28, 2023Copper Contributor
Quick Access Toolbar keeps disappearing in Excel
Each time I open an excel workbook, the QAT is gone. I can fix it to have it reappear and save the file. When I open the workbook again, the QAT has disappeared. What gives? Thank you. Dorn
dapper49
Mar 30, 2023Copper Contributor
Thank you for your help. I tried each of your suggestions, but the problem kept occurring.
But I noticed that the problem was only on worksheets that had external links,
I found out that I could go to Data >Queries and Connections > Edit Links. then I clicked on the Startup prompt. I chose "Don't display the alert and update links". It automatically updates links and the QAT always appears,
Now I think all is good once again. Thanks.