| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find and replace does not work in a linked cell
I have a column in a worksheet that contains links to other cells within the
same workbook, i.e. formula is ='lease Aug 2005'!F20. I want to perform a find on Aug and replace it with Sept (to update the cells with September's information) but am having no luck. It keeps looping into an "Update Values" dialog box. The workbook was originally created in Excel 2000 and I am now using Excel 2003. Any suggestions would be most welcome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does "find and replace" work within a chart? | Charts and Charting in Excel | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY? | Excel Discussion (Misc queries) | |||
| find and replace cell reference to a new worksheet | Excel Worksheet Functions | |||
| How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
Threaded Mode
