View Single Post
  #1   Report Post  
davyb
 
Posts: n/a
Default 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