Disable 'Update Links' message when opening workbook

  • We receive a lot of spreadsheets from our clients that contain links to their internal servers. Obviously we can not update these links and we get the following error:


    Code
    1. "This workbook contains one or more links that cannot be updated"


    I'm trying to run some VBA on these as they come in and I'm having a few problems. This being one of them.


    Is it possible to disable all linking with VBA or maybe another way so it doesn't interrupt the script?


    Andy.

  • Re: Links to other spredsheets.



    I'
    the error is where I've highlighted in bold. "argument not optional" is what I get. I've tried putting set = before but the error is the same. Also I'm not 100% its in the right place. I don't know if its obvious but I'm no VBA expert haha.