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:
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.