When you use Excel, you find that features such as new, open, save, and print files under the File menu appear dimmed and are not working properly. How could that be?
We know that for the computer, all the changes must be saved, if not saved the computer will not automatically remember the user changes. Excel also, although it does not pop save prompts, but in fact it has written in a file this change, the file is "excelxx.xlb."
In Excel 2010, the file name is excel14.xlb; if it is Excel 2007, the file name is excel12.xlb.
For Windows 7/vista operating system, enter C:usersxxxappdataroamingmicrosoftexcel in the Address bar (XXX here refers to your account name)
Small tip: The AppData folder is hidden by default, and you can click Organization-folder and search options in Windows Explorer, and in the View tab of Folder Options, select Show hidden files, folders, and drives.
For the Windows XP operating system, enter c:documents and Settingsadministratorapplication datamicrosoftexcel in the address bar
Find the. xlb file, and then restart Excel when you delete it. This method can help us solve some problems caused by bad operation.