| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel 2010 Replace worksheet name in formula linked to a different workbook
I am trying to replace a worksheet name in a formula linked to a different workbook using Excel 2010.
Current: ='M:\ACCOUNTING\Mike\2010 Sales\6 - Period 2010\06152010\[3 - BoulderWE061510.xls]Weekly Sales'!$E$46 Need to Replace with:='M:\ACCOUNTING\Mike\2010 Sales\7 - Period 2010\06222010\[3 - BoulderWE062210.xls]Weekly Sales'!$E$46 ok so here is my issue. Using Excel 2003 and/or 2007 I simply would use Replace 0615 with 0622 I would have to hit esc and it would give me a #REF! error. Then I would replace 6 - Period with 7 - Period and presto it was updated. Now using Excel 2010 when I try to esc it stops. Anyone? Last edited by gcg : July 14th 10 at 10:18 PM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula problem with Excel 2010 | Excel Worksheet Functions | |||
| Cells linked to another workbook with a formula. | Excel Worksheet Functions | |||
| Updating linked cells within a workbook, from worksheet to workshe | Excel Discussion (Misc queries) | |||
| Find & Replace a link to another worksheet in the same workbook | Excel Worksheet Functions | |||
| Replace worksheet name in formula linked to a different workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
