2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

'Research' freezes my Excel 16

Alt + Left click is a shortcut for research in Excel 16, and it is causing an annoying problem for me.

When I open any excel workbook and "Alt + Left click on a cell for the first time", my excel stops working for roughly 3 minutes. It happens even on an empty sheet.

After 3 minutes, Excel eventually works. Alt + clicking on a cell does not freeze Excel anymore. But the problem is not gone. Normally, moving from a cell to another by clicking should take zero time. But, when I click on a cell and then alt + click on another, the cursor stutters for a split second like running a game on a computer that fails to meet the requirements.

I asked AIs to fix the problem but they failed equally.

Things I tried:

  1. Disabling Research through VBA.

- I ran a code on the immediate panel(the thing that Ctrl + G opens). The code looks like : "Application.CommandBars("Research").Enabled = False"

- I don't like it because its only temporary.

- Most importantly, the 3 minute freeze is still there. (I really hope to know why)

  1. Disabling Hardware Acceleration

- It didnt work.

  1. Resetting Microsoft Office Applications through Windows Setting.

- Even this didnt work.

  1. Disabling Add ins.

- I dont have any active Add in.

  1. Removing Excel file in appdata folder

- It didnt work.

Could anyone suggest me a thing to try?

submitted by /u/asdf9999999999
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#no-code spreadsheet solutions
#real-time collaboration
#rows.com
#machine learning in spreadsheet applications
#row zero
#cloud-based spreadsheet applications
#Excel 16
#Alt + Left click
#Research
#freeze
#VBA
#Hardware Acceleration
#Microsoft Office Applications
#Add ins