Task pane disappears when you start Excel

[The Recruiter]

Hello everyone,
I am facing very strange problem with the Excel. I have installed the MS Office properly, and for some days it was working flawlessly. From last two days I am getting some strange results after opening an excel. Many times I have observed that the task pane disappears after starting the Excel. I am having anti-virus which is properly updated, so I think that there should be no issue of virus or malware. Still I am not able to fix this problem. Please tell me some solution so that task pane will appear even after starting Excel.

[kattman]

Normally many times the task pane disappears when the following conditions are met :

1. The check box Show at startup is activated in the task pane.
2. One or more open Excel files automatically when you start to include the file and any custom plug Personal.xls.

If you avoid these conditions, then you should not get an error.

[Macarenas]

By default, load Excel files of the following folders on your hard drive at home (where user-name is your user name) :

• Office \ Office11 \ Xlstart \ Microsoft Excel 2003-C: \ Program
• \ Microsoft \ Excel \ Xlstart username C: \ Documents and Settings \.
• The folder that is specified in the table at startup, open all files in (in the General tab of the Options dialog box).

Hope that this help can fix your error.

[JonathanD]

To avoid this behavior this behavior, do not load files at startup that are mentioned by the 'Macarenas'. When you start Excel, all the files that are located in the XLStart folder are automatically opened. This behavior occurs regardless of the type of file. Additionally, if you specified an alternative startup folder for Excel, every file in that folder is also automatically opened. To specify an alternative startup folder, in Microsoft Excel 2002 or Microsoft Office Excel 2003, click Options on the Tools menu, and then click the General tab. In Microsoft Office Excel 2007, click the Microsoft Office Button, click Excel Options, click the Advanced tab, and then locate the General section.

[Eric B]

If you created a book Personal.xls, you can follow the steps :

1. On the Tools menu, select Macro and then click Visual Basic Editor.
2. In the Project Explorer window, expand VBAProject (PERSONAL.XLS).
3. Expand Microsoft Excel Objects.
4. Double click on this book.
5. In the code window that opens, type the following code
   

   Private Sub Workbook_Open () 
     On Error Resume Next
      
     Application.CommandBars ( "Task Pane"). Visible = True 
     End Sub

6. On the File menu, click Save Personal.xls.
7. On the File menu, click Close and Return to Microsoft Excel.
8. Exit Excel.

[NIcaBoy]

For creating a book Personal.xls, follow the steps :

1. Start Excel
2. On the Tools menu, select Macro and then click Record New Macro.
3. In the Record Macro dialog box, click Personal Macro Workbook in the Store Macro In list.
4. Click OK.
5. In the Stop Recording toolbar, click the Stop button.
6. On the File menu, click Exit.
7. When prompted to save changes to your Personal Macro Workbook, click Yes

After creating the personal.xls, you can proceed with the steps that are mentioned by the 'Eric B'.