W
warnimont
How do i get the view, task pane to auto-load each time i
start excel?
start excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
TOOLS > OPTIONS > VIEW - Startup Task Pane Tick/Untick
J
Judy Freed
Tools, Options, click the View tab and under "Show", click Startup Taskpane.
Judy Freed
Systems Development
UNC Charlotte
Judy Freed
Systems Development
UNC Charlotte
D
Debra Dalgleish
If you have checked 'Startup Task Pane' under Tools>Options, View tab,
and the Task Pane doesn't stay open, you may have a hidden workbook that
opens automatically as Excel starts up (e.g. Personal.xls). This causes
the Task Pane to closes despite the Task Pane setting. You can change
the Registry, or add a macro to the workbook that's opening automatically.
There are instruction for a macro in the following MSKB article:
XL2002: Task Pane Disappears When You Start Excel
http://support.microsoft.com/default.aspx?id=293820
Or, you can force the Task Pane to stay open by making a change to the
Registry (make a backup first!):
1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 10.0, Common, and click on General
5. Choose Edit>New>DWORD Value
6. Type the name for the DWORD: DoNotDismissFileNewTaskPane
7. Press Enter to complete the renaming
8. Choose Edit>Modify
9. Type 1 as the value and click OK
10. Close the Registry Editor
'===============================
and the Task Pane doesn't stay open, you may have a hidden workbook that
opens automatically as Excel starts up (e.g. Personal.xls). This causes
the Task Pane to closes despite the Task Pane setting. You can change
the Registry, or add a macro to the workbook that's opening automatically.
There are instruction for a macro in the following MSKB article:
XL2002: Task Pane Disappears When You Start Excel
http://support.microsoft.com/default.aspx?id=293820
Or, you can force the Task Pane to stay open by making a change to the
Registry (make a backup first!):
1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 10.0, Common, and click on General
5. Choose Edit>New>DWORD Value
6. Type the name for the DWORD: DoNotDismissFileNewTaskPane
7. Press Enter to complete the renaming
8. Choose Edit>Modify
9. Type 1 as the value and click OK
10. Close the Registry Editor
'===============================