+ Reply to Thread
Results 1 to 2 of 2

Lock cells from auto update

  1. #1
    Registered User
    Join Date
    09-14-2006
    Posts
    6

    Lock cells from auto update

    Hello,

    i am calling values from another excel sheet with
    =[MasterScope_Manufacturing.xls]Manufacturing!C15

    is there any way to lock the values imported so they do not update anymore if the values in masterscope.xls change unless I want it to ? the value in masterscope might change but i do not want them to show up in my other sheet.


    best regards
    godspeed

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    you should remove this formula and manually update value when you want.

+ 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