naxshack.blogg.se - Open xsb file

This directory is supposed to be trusted by Excel as a repository of "OK to load" workbooks. You should understand that the actual directory may differ, depending on your version of Windows and which version of Excel you are using. The workbook is created, by default, in a directory similar to the following:Ĭ:\Users\Allen\AppData\Roaming\Microsoft\Excel\XLSTART It is also possible that the directory in which the Personal workbook is stored has somehow become "untrusted" to Excel. (If you don't have a backup, the you'll need to recreate your Personal workbook from scratch.) While the above steps can temporarily make your Personal workbook active, it won't fix the problem in the long run-you need to replace the file with a backup that Excel doesn't think is corrupted.

If the Personal workbook is listed as disabled, select it and then click Enable.Įxcel disables any add-ins that it thinks are corrupted in some way or that it believes won't work properly with Excel.

Excel displays a dialog box that shows any add-ins that Excel has disabled.

Using the Manage drop-down list (bottom of the dialog box), choose Disabled Items.

Click Add-Ins at the left side of the dialog box.

In Excel 2010 or a later version display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. The first thing you want to do is check to see if the Personal workbook has somehow become disabled. There could be a couple of different causes for this problem. The workbook is in its correct location and he can open it directly-it just will not load automatically as it is supposed to. He has confirmed that it is not loading, although it has in the recent past. All of a sudden Alan's Personal.xlsb workbook stopped loading whenever he started Excel.