Posts by Tweety_19

  • Edit Links Problem "Links Cannot Be Updated" Error Always Occurs

    I have a spreadsheet which pulls data from other spreadsheets. Every time I open this, I get the "This workbook contains one or more links that cannot be updated error."

    Updating skips past this and all works fine. Choosing edit links shows me that all links have an "OK" status, that the updates are automatic, and I have the startup prompt set to "Don't display the alert and update links".

    So why does this keep popping up, and how can I get this to stop?

  • Protecting all worksheets except one

    I have a code that protects all worksheets within the open workbook, and it works very well. I've not included a worksheet that I don't want to protect. The worksheet is called "LogDetails". Is it possible to insert some code into the following to exclude protecting this specific tab?


    Code
    Sub Protect()
'
' Protect Macro
' Protects all worksheets. Protects without a password.
'
For i = 1 To Sheets.Count
Sheets(i).Protect
Next i
End Sub