Note that these are default locations depending on how Excel was installed, the files could be elsewhere. In each instance, "username" should be replaced with the name of your user account. The following are two common areas for the files to be stored:Ĭ:\Users\ username\AppData\Roaming\Microsoft\OfficeĬ:\Users\username\AppData\Local\Microsoft\Office Where they are normally located depends on the version of Windows you are using. All you need to do is to look for files (in Windows) that end with the. The second method of backing up your QAT is required if you are using Excel 2007, but will also work with later versions of Excel. You can store it where you store your other backups, and then reuse it by following the above steps but choosing to import in step 5. The file created in step 7 is your backup file. Click on Cancel to dismiss the Excel Options dialog box.Excel saves the customization file where you specified in step 6.
Using the controls in the dialog box, select a location where you want the backup file saved.
Custom shortcut bar excel 2016 Pc#
Recently his PC crashed and Excel had to be reinstalled. Kym normally sets up a personalized Quick Access Toolbar when using Excel.
0 kommentar(er)
