+ Reply to Thread
Results 1 to 1 of 1

Locking Formula links from Other Workbooks

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    Los Angeles, California
    MS-Off Ver
    Excel 2011
    Posts
    1

    Locking Formula links from Other Workbooks

    Can someone explain how to lock formula links from one workbook to another using Excel 2011? I will explain exactly what I mean. Please see the attached sample files and description below for reference:

    I have already linked prices from "Price List Sample" to their matching items in "Invoice Sample". However, if I close the invoice sample and add an extra line in the price list sample, the rows get pushed down and the formulas no longer match correctly. For instance, if I add a line above the item, "Snacks" in line 2 of the price list, the formulas will no longer correspond correctly when the invoice is opened back up.

    Is there a way to apply a formula link that updates accordingly when items are added to the price list?

    Thanks in advance.
    Attached Files Attached Files

+ Reply to Thread

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