Replace formula with current value

[davyb]

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.

[NlCO]

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