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.