Results 1 to 2 of 2

Maintain formula "Links" when sheet moved

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2009
    Location
    ontario canada
    MS-Off Ver
    Excel 2003
    Posts
    64

    Maintain formula "Links" when sheet moved

    Is there a way to maintain established links when a work book is moved. I will have a cell formula that returns information from another workbook. Any time the workbook is moved or remnamed I have to manually update all the formulas. Is ther any way to lock this formula link. Example formula provided.

    =SUMPRODUCT(('H:\MM_PLANNERS\Task Planning\OPR INFO\OPR DATA TRACKING\[1 HOURS WORKED TRACKING.xls]JAN 11'!$B$4:$B$5000="OT")*('H:\MM_PLANNERS\Task Planning\OPR INFO\OPR DATA TRACKING\[1 HOURS WORKED TRACKING.xls]JAN 11'!$L$4:$L$5000))
    Last edited by pdmkh; 08-13-2011 at 01:19 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1