Results 1 to 2 of 2

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

  1. #1
    Join Date
    Jan 2012
    Posts
    25

    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?

  2. #2
    Join Date
    Jun 2011
    Posts
    487

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

    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

Similar Threads

  1. Want to add a Excel Worksheet link on Outlook Message
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 12:14 PM
  2. Getting a error saying invalid formula in Excel Worksheet
    By Thedevotee in forum Windows Software
    Replies: 3
    Last Post: 11-01-2012, 06:03 PM
  3. Replies: 8
    Last Post: 04-12-2011, 11:24 AM
  4. Replies: 5
    Last Post: 14-05-2011, 10:36 AM
  5. How to copy worksheet in Microsoft Excel 2010?
    By Bharat89 in forum Windows Software
    Replies: 3
    Last Post: 09-01-2010, 04:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,652,864,434.14344 seconds with 17 queries