| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Find and Replace Formula Links | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
Hybrid Mode
