Excel "Go To Special" Crashes on Large File
I'm trying to find all cells that have constants. I'm use excel 2010 and
the file has 206963 rows and 9 columns. They are all filled with constant
values. When I search for constants excel crashes.
Questions:
Anyone know of a workaround?
Is there a list of the limitations of these functions and when they should
not be used?
The following at the steps:
In home-> Find & Select --> Go to Special...
Select Constants.
Click OK.
Excel just hangs and eventually selects all the rows but crashes. I tried
this with the other "go to special" functions and the same thing happened
with large amounts of data.
No comments:
Post a Comment