ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does the research box keep popping up? (https://www.excelbanter.com/excel-discussion-misc-queries/207571-why-does-research-box-keep-popping-up.html)

John of Romsey Town

Why does the research box keep popping up?
 
My Excel 2007 appears to have developed a fault.
After a few minutes of use (variable amount of time) the Research "search
for" box pops up by itself whenever I press a key or click on a cell. I can
turn if off again from the Review tab, but as soon as I press another key or
cell, it pops back up again. This makes Excel unusable and I am forced to
turn Excel off and on again, to allow another few minutes use before the bug
reappears. It happens with any spreadsheet.

This has only just started to happen after 1 year of use. I have no idea
what is causing it or how I cure the problem. Does anyone have any
experience of this? Should I reinstall Excel or is it something I am doing
wrong?

V grateful for advice

John

ExcelBanter AI

Answer: Why does the research box keep popping up?
 
Hi John,

It sounds like you may have accidentally turned on the "Research" feature in Excel, which is causing the search box to pop up every time you press a key or click on a cell. Don't worry, it's an easy fix!

Here's what you can try:
  1. Click on the "Review" tab in the Excel ribbon.
  2. Look for the "Research" button in the "Proofing" section of the ribbon.
  3. If the button is highlighted (i.e. it looks like it's been clicked), click on it again to turn it off.
  4. If the button is not highlighted, try clicking on it once to turn it on, and then click on it again to turn it off.
  5. Close and reopen Excel to see if the problem has been resolved.

If the above steps don't work, you can also try resetting Excel to its default settings. Here's how:
  1. Close Excel.
  2. Press the Windows key + R on your keyboard to open the "Run" dialog box.
  3. Type
    Code:

    excel.exe /safe
    (without the quotes) and press Enter.
  4. Excel will open in "Safe Mode" with default settings.
  5. Click on the "File" tab in the Excel ribbon, and then click on "Options".
  6. Click on "Add-Ins" in the left-hand menu.
  7. At the bottom of the screen, next to "Manage", select "COM Add-ins" and click "Go".
  8. Uncheck any add-ins that are selected, and then click "OK".
  9. Close Excel and reopen it normally.

Hopefully one of these solutions will work for you and you'll be able to use Excel without any further issues. Let me know if you have any other questions or concerns!

Art

Why does the research box keep popping up?
 
The research tab should not make excel unuseable. It couyld stay in the side
while working in excel. However, the research tab pops up when pressing the
ALT key while clicking any cell. Make sure you are not holding down the ALT
key.



ART.




"John of Romsey Town" wrote:

My Excel 2007 appears to have developed a fault.
After a few minutes of use (variable amount of time) the Research "search
for" box pops up by itself whenever I press a key or click on a cell. I can
turn if off again from the Review tab, but as soon as I press another key or
cell, it pops back up again. This makes Excel unusable and I am forced to
turn Excel off and on again, to allow another few minutes use before the bug
reappears. It happens with any spreadsheet.

This has only just started to happen after 1 year of use. I have no idea
what is causing it or how I cure the problem. Does anyone have any
experience of this? Should I reinstall Excel or is it something I am doing
wrong?

V grateful for advice

John



All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com