Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Location
    philadelphia, Pennsylvania
    Posts
    72
    Thanks
    11
    Thanked 0 Times in 0 Posts
    I have several workbooks with several sheets in each. All the sheets are protected individually. All the sheets are linked to a main raw data file. The main data file was moved to a different directory which messed up the links. I attempted to edit the source but apparently would need to unlock EVERY sheet in each workbook to do that ... Does any one know of a way to do a "mass unlock" etc so I can get the sources corrected without driving myself crazy? THANKS!

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    [quote name='trish12' post='784924' date='16-Jul-2009 08:25']I have several workbooks with several sheets in each. All the sheets are protected individually. All the sheets are linked to a main raw data file. The main data file was moved to a different directory which messed up the links. I attempted to edit the source but apparently would need to unlock EVERY sheet in each workbook to do that ... Does any one know of a way to do a "mass unlock" etc so I can get the sources corrected without driving myself crazy? THANKS![/quote]
    Hi Trish
    As far as I know you will have to unlock every sheet - no way around it. For what its' worth I usually write a macro to unlock/relock sheets in this situation. If you want help with that, let us know what version of Excel you are using.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It would save some trouble and even prevent the need for the macro, if you moved the file back and opened any files which links to it. This should fix all the links.

    Now open up the linked file, and will all the other files open, SAVE AS the linked file to the new location. The references to the file should then be reset to the new location.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •