Replace formula with current value
 

Hi

does anyone know how I can replace a page full of cells with formulas
pointing to cells in another workbook with the numerical value of what
is currently being displayed.

Whenever I open this workbook I get a prompt to update - but I don't
want to update this workbook ever again so the values need to be just
as they are.


--
davyb
------------------------------------------------------------------------
davyb's Profile: http://www.excelforum.com/member.php...o&userid=26401
View this thread: http://www.excelforum.com/showthread...hreadid=401082

Hi, select all the formulas you want to turn into data.
Press CTRL+C
Then press the right button of your mouse and select Paste Special
Then select "Values" and Ok

That's all

Saludos

NlCO


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=401082