Replace Microsoft Excel 2010 Worksheet name via formula and link it to other

I am trying to replace a worksheet name in a formula linked to a different workbook using Excel 2010.
Current: ='M:\ACCOUNTING\xxx\2010 Sales\6 - Period 2010\06152010\[3 - BoulderWE061510.xls]Weekly Sales'!$E$46
Need to Replace with:='M:\ACCOUNTING\xxx\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?

Just a minor note, if you are using excel 2007 make sure the following options is checked in.
1. go to excel options
2. advanced
3. when calculating this workbook
4. check in a) update links to other documents b) save external link values

OR

Use FIND and REPLACE this way:
FIND:6 - Period 2010\06152010
REPLACE:7 - Period 2010\06222010