Delete the formulas of webpage, copied & pasted on excel sheet
 

I am using Office 2003 & would like to copy & paste on a Excel sheet a
webpage with coloums containing text but also with hidden formulas.

I would like the hidden formulas to be deleted from the excel sheet. due to
this hidden formulas the worksheet takes time to open as the size increases
to Mb.

Would apprecaite your help.

A possible solution is to replace all the formulae in the worksheet by their
values rather than searching throught the entire sheet looking for formulae:

Select all the cells in the worksheet
Edit Copy
Select cell A1
Edit Paste Special (check the value button)
--
Gary's Student


"Mustafa Abedin" wrote:

I am using Office 2003 & would like to copy & paste on a Excel sheet a
webpage with coloums containing text but also with hidden formulas.

I would like the hidden formulas to be deleted from the excel sheet. due to
this hidden formulas the worksheet takes time to open as the size increases
to Mb.

Would apprecaite your help.