MPW
Well-known Member
- Joined
- Oct 7, 2009
- Messages
- 571
- Office Version
- 365
- Platform
- Windows
I have noticed in the older versions of Excel, that the search seemed to fail if the text in the cells had too many keystrokes.
Was this true and if so, was it fixed somewhere along the line?
Many moons ago I began using loops to find/replace instead of using the built in feature. I would loop cell by cell and character by character. It was actually faster than it sounds and enabled me to really get specific with the find replace.
I have recently noticed that some of the machines using this process are freezing up. In addition, the resource meter pegs into the red. Even on faster machines. I do not seem to have any problems with my 365 office version, but Office 16 does have this problem. I have noticed that if the Excel window is minimized and then restored to the old size it will free it up sometimes..
Anyway I just thought I would see if anyone had a faster solution than what I have been using.
Was this true and if so, was it fixed somewhere along the line?
Many moons ago I began using loops to find/replace instead of using the built in feature. I would loop cell by cell and character by character. It was actually faster than it sounds and enabled me to really get specific with the find replace.
I have recently noticed that some of the machines using this process are freezing up. In addition, the resource meter pegs into the red. Even on faster machines. I do not seem to have any problems with my 365 office version, but Office 16 does have this problem. I have noticed that if the Excel window is minimized and then restored to the old size it will free it up sometimes..
Anyway I just thought I would see if anyone had a faster solution than what I have been using.