How to disable the research pane in Excel?

Anonymous
2024-04-15T07:26:16+00:00

The research pane automatically pops up while using Excel. Not sure is there any trigger keys for this. But I'm unable to disable the research pop ups once it is activated. Currently we close all the excel files and reopen them only then the pane is disabled.

Is there any way to disable the pane permanently?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2024-04-15T08:27:58+00:00
  • Start Excel.
  • Press Alt+F11 to activate the Visual Basic Editor.
  • Press Ctrl+G to activate the Immediate window.
  • Enter the following line, or copy/paste it from this post into the Immediate window:
     
    Application.CommandBars("Research").Enabled = False
  • With the insertion point anywhere in the line, press Enter.
  • Press Alt+F4 to close the Visual Basic Editor.
  • The Research task pane shouldn't appear any more.

Was this answer helpful?

1000+ people found this answer helpful.
0 comments

46 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-07-18T15:08:30+00:00
    • Start Excel.
    • Press Alt+F11 to activate the Visual Basic Editor.
    • Press Ctrl+G to activate the Immediate window.
    • Enter the following line, or copy/paste it from this post into the Immediate window:
       
      Application.CommandBars("Research").Enabled = False
    • With the insertion point anywhere in the line, press Enter.
    • Press Alt+F4 to close the Visual Basic Editor.
    • The Research task pane shouldn't appear any more.

    Genius! Thanks a lot!!!!

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2024-07-18T05:01:08+00:00
    • Start Excel.
    • Press Alt+F11 to activate the Visual Basic Editor.
    • Press Ctrl+G to activate the Immediate window.
    • Enter the following line, or copy/paste it from this post into the Immediate window:
       
      Application.CommandBars("Research").Enabled = False
    • With the insertion point anywhere in the line, press Enter.
    • Press Alt+F4 to close the Visual Basic Editor.
    • The Research task pane shouldn't appear any more.

    You are lifesaver, great thanks. It's really worked.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  3. Anonymous
    2024-07-09T20:48:23+00:00

    How do disable it permanently? I followed the steps you indicated but it keeps happening each time I reopen excel and copy something.

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  4. Anonymous
    2024-07-02T14:28:14+00:00

    for me it keeps coming back. Is there any way to disable permanently?

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments