Update Links - VBA?

Is there a way to update links to external Excel workbooks without opening the main workbook that contains the links and updating the links manually?

In other words can I update external links while the workbook is closed?

LVL 13
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
No. The workbook must be opened.
nike_golfAuthor Commented:
I had a feeling that was the case... just thought I would check.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.