+ Reply to Thread
Results 1 to 3 of 3

How do I stop a user from accidentally opening linked files?

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    How do I stop a user from accidentally opening linked files?

    My main workbook has links for data from two linked workbooks. The cells that gather this data are protected, as the data is for display only. However, if a user double-clicks on one of these cells, he gets the warning that the cell is locked (that's OK), but the linked file then opens. I don't want it to.

    I protected the linked file to prevent editing, but I don't want it to open at all. Link updating is automatic with no user intervention. I need to update the linked files periodically, but the user of the main file never needs to see the linked files.

    The worksheets must be protected with Select Unlocked Cells ticked, as there are password-protected regions on the worksheets that the user accesses with a password.

    How do I stop the linked files opening when the user double-clicks on a cell whose formula refers to the linked file?
    Last edited by Hambone70; 02-09-2011 at 10:27 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: How do I stop a user from accidentally opening linked files?

    When you protect the sheet, if you untick 'select locked cells', the user shouldn't be able to click on the cells at all. Does that solve the problem?

  3. #3
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Re: How do I stop a user from accidentally opening linked files?

    I can't do that, as there are password-protected locked areas of the worksheet that the user needs to access. If Select Locked Cells isn't ticked, the password protection and access of locked cells doesn't work.

    Why does the linked file open by simply double-clicking on the cell that references it anyway?
    Last edited by Hambone70; 02-09-2011 at 10:47 AM.

+ 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