This is a strange one...
My manager was using a replace all function, on a field of 16C x 3,000R = 48,000 cells. Except he made a typo on the replace function.
So now excel is asking him for a file path everytime it tried to replace something in each cell...
Is there a way to mass cancel the "replace all" ???
(holding down the Esc button gives about 4-5 cells per second (it will take around 3 hrs to cancel it all if done manually...)
Anyone know of a quicker solution?
My manager was using a replace all function, on a field of 16C x 3,000R = 48,000 cells. Except he made a typo on the replace function.
So now excel is asking him for a file path everytime it tried to replace something in each cell...
Is there a way to mass cancel the "replace all" ???
(holding down the Esc button gives about 4-5 cells per second (it will take around 3 hrs to cancel it all if done manually...)
Anyone know of a quicker solution?