If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Replace "insert function" with "edit formula" button in fourmula b | 13brian | General Discussion | 0 | August 24th, 2005 08:49 PM |
IF & VLOOKUP FORMULA | taxmom | Worksheet Functions | 3 | March 2nd, 2005 03:35 PM |
Replace worksheet name in formula linked to a different workbook | Jen and Debra | General Discussion | 1 | February 10th, 2005 11:02 PM |
Alternative formula to HLookup | Bernie Deitrick | Worksheet Functions | 0 | March 26th, 2004 12:53 PM |
Search and replace string in formula with string from cell | Ingar | Worksheet Functions | 2 | November 3rd, 2003 01:29 AM |