•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel 2019
#search and replace
#stuck in a loop
#Microsoft Excel
#cannot find a match
#cloned Tab
#formulas
#intervene
#control
#newly selected tab
#columns
#rows
#searching
#tab
#OK
#update