•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel 2019 - Search Replace is stuck in loop after changing Tab
Our take
If you find yourself stuck in a loop with Excel 2019’s search and replace feature after switching tabs, there’s hope for regaining control. This issue often arises when a search operation is interrupted, leaving Excel unable to locate the original tab and search context. With approximately 10,000 columns and 15,000 rows in your spreadsheet, the problem can feel overwhelming. Fortunately, there are strategies to intervene and resolve this glitch, allowing you to regain access to your work without the endless clicking. Let’s explore effective solutions.
I needed to perform a search & replace (S&R) on a cloned Tab to update formulas. I didn't realise it hadn't completed the 'S&R' and selected another tab in Excel. Now it is stuck in a loop saying: Microsoft Excel cannot find a match.
There are approx 10k columns and 15k rows, and it wont allow me to return to the Tab it is searching, and I suspect it's actually looking in the newly selected tab. Is there a way to intervene and regain control or am I destined to clicking on OK till my next birthday :(
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Horribly annoying change to Search in ExcelSo I use windows 10 and Excel (2019 I believe) and I have not updated or done any changes when out of nowhere (I even had excel opened) the search changed - basically before whenever I did a search and it didn't find anything, it would just show "0 results" or "0 cell(s) found" but now today, for whatever unknown reason, it instead pops up this annoying window that says; "Microsoft Excel We couldn't find what you were looking for. Click Options for more ways to search" combined with this even more annoying ERROR sound effect. How do I change back to before? I use Excel 25 hours per day, 999 different workbooks, I will run into this all the time and see this hideous, unnecessary box and hear this god-awful sound effect 6 billion times per day now? - I've tried restarting excel - Restarting entire PC - Search from the top, clicking the "find and select" shit instead of normal ctrl+f - Deleted all the garbage in %appdata%\Microsoft\Excel\ This problem just won't go away. submitted by /u/No_Lies4 [link] [comments]
- Find and Replace - No option to look in values?https://preview.redd.it/ynaenmtog7qg1.png?width=508&format=png&auto=webp&s=3ff5dad44c6daef6f77bf8e2db7ce51e360ee2ac This is a new one for me. Today I wanted to use find and replace to change some values in a spreadsheet. However, the dialog only gives me the option to look in formulas. I've run all available updates, did a full repair on Office, and tried multiple different files; this is present everywhere. Any idea how to fix this? Running Excel version 2602 Build 16.0.19725.201264 64-bit. Thanks in advance for any suggestions! submitted by /u/RavingLuhn [link] [comments]