Quote:
Originally Posted by gcg
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?
|
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
all the best