Hey Amit,
use find and replace option "find value =" and "replace value
'="... and after past sheet again use find and replace
function now new "find value '=" and "replace value ="
On Mon, Aug 29, 2011 at 1:08 PM, Amit Desai (MERU)
wrote:
> Dear Friends,
>
> ** **
>
> Sinc
Dear Friends,
Since the performance of excel was slow... & I have more than 1000 formula..
I have opted for following
1) Kept the formula only in first line & in following line made all cells
to value,
2) The formulas in 4 sheets were linked to "sheet1". Sheet1 was every time
refre
