•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
'Research' freezes my Excel 16
Our take
Experiencing freezes in Excel 16 when using the "Alt + Left click" shortcut for research can be incredibly frustrating. This issue causes a significant delay, even on empty sheets, as Excel becomes unresponsive for up to three minutes. Although the stuttering cursor eventually resolves itself, the underlying problem remains. Previous attempts to fix the issue, such as disabling Research through VBA, turning off hardware acceleration, and resetting Office applications, have not yielded results.
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:
- 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)
- Disabling Hardware Acceleration
- It didnt work.
- Resetting Microsoft Office Applications through Windows Setting.
- Even this didnt work.
- Disabling Add ins.
- I dont have any active Add in.
- Removing Excel file in appdata folder
- It didnt work.
Could anyone suggest me a thing to try?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Constant Freezing and CrashingHi everyone, Trying to troubleshoot a strange Excel issue affecting a number of users in our environment and I’m curious if anyone else has seen something similar. Users report that Excel will lock up when switching between applications or when copying between Excel workbooks. The freeze can last around 10–30 seconds, after which Excel either recovers or occasionally crashes completely. If excel recovers for several more seconds clicking a cell sometimes selects the wrong cell or highlights an entire range instead of the single cell that was clicked. For example, the user clicks one cell but Excel highlights several cells nearby. Maybe an issue with DPI scaling issues? Some environment details: Microsoft Excel (Microsoft 365 Apps for Enterprise) Monthly Enterprise Channel Most affected machines running version 16.0.19530.20226 Some users on 16.0.19426.20260 Mix of Windows 10 and Windows 11 The issue appears across different machines and hardware, including multiple laptop brands and models with both lower and higher specs, so it doesn’t seem to be related to performance. It also doesn’t appear tied to workbook size as the issue happens with both small spreadsheets and larger ones. Resources look normal when the freeze occurs. Typical triggers seem to be: copying between Excel workbooks switching between Excel and another application (browser, Outlook, etc.) returning focus back to Excel Files are opened from a mix of locations: OneDrive SharePoint OneDrive SharePoint sync folders local files Users are working on laptops connected to external monitors, usually with the laptop screen still open as well. Some setups do have mixed display scaling (e.g. laptop at 150% and monitor at 100%) which could be causing the crashes? Things we’ve already tried: disabling hardware graphics acceleration disabling Live Preview disabling background error checking setting Excel to power saving GPU mode in Windows graphics settings testing across different machines and workbooks The issue appears specific to Excel, since other applications on the same machines don’t show similar freezing or input issues. Has anyone run into something similar with recent Microsoft 365 builds or seen Excel behave like this when switching between apps? Any suggestions for additional things to test would be really helpful. I am loosing my mind. submitted by /u/Any-Ticket4332 [link] [comments]
- my excel freeze for even simple things like boldening/italicising cells. why? solution?i have an excel file i maintain. its a small file, not big, a few kb. but sometimes, when formatting cells, say bolding text or italicising, my excel stops responding and freezes. the cells arent links, they just contain bog standard text of one or two words. it doesnt happen all the time, but occasionally. but its still annoying. my own laptop has excel 2021. my work laptop has 365 and sometimes it happens there too, so i think this is some sort of problem with excel generally. has anyone else experienced this and can advise on a solution? thakns submitted by /u/Illustrious_Fig_8537 [link] [comments]
- How to stop Excel Online from being so slow?Since an update a few years back, I want to say two or three (it was some UI changes mostly) my Excel Online has just been unbearably slow. Just a few minutes ago I added a new sheet to an existing file. For some background it was previously a single sheet 13x47 table with 2 columns of simple calculations (one adding up a couple columns, and another doing some division), 282 cells being used. The new sheet took 2 minutes to process and actually be created. It is currently a 6x21 table, but by the time I created the 3rd of 6 columns it froze and had an error then reloaded itself putting me back to only 2 columns made. It did this again then 3 times more before I finished the table, each time taking several minutes. There is not a lot of data in the file, there's simple calculations without function calls, and I have no issues with my internet connection. I could make a new file and still have the same issues. I often have to reload a file 10+ times before I can complete some simple data entry. I do know there's a banner that pops up from time-to-time about my internet settings but clicking the hyperlink that comes with it just crashes the file again. I also know that Firefox (the browser I use) will occasionally try to get me to close the page because it's lagging out so bad. Lastly, the files work fine on my phone browser. Anyone know what could be causing this? Because at this point it's honestly faster to use pen and paper if not for the fact I already have all the old data online. submitted by /u/AltoniusAmakiir [link] [comments]
- Anyone experiencing UI issues with Excel Labs?For a while, the Excel Labs add-on seemed to work fine for me. For a few months now I've been getting a lot of stuttering issues in Excel. These make the UI slow and unrensponsive, but have nothing to do with actual calculations being executed; just clikcking or moving through cells becomes laggy. If I close the workbook and open it again it fixes itself, but going through that multiple times an hour feels wrong. Any tips? I really like the advanced formula enviroment and kinda don´t wanna uninstall it. submitted by /u/el_porongorila [link] [comments]
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