Excel personal workbook not opening every time
Posted on 2011-10-17
The Excel personal workbook is not opening every time Excel is started. Every 2 to 4 times I open an Excel workbook, the personal workbook will become unavailable. The problem usually, but not always, is proceeded by my getting the following message when closing an Excel workbook: "Personal.xlsb is locked for editing" by me. The personal workbook will not load after that when opening other Excel workbooks.
To see why Excel might consider the personal workbook to be locked for editing I started the task manager and noticed that while the Excel application was not listed as an active application, the task manager listed the excel.exe process as active on the processes tab. So even though I had closed Excel the process was still running. If I force the process to close I am able to access the personal workbook the next time I open an Excel file. But the problem appears again after I close and open Excel workbooks a couple of times.
Any ideas on what might be causing this problem and how to fix it?