• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Remove Links

G

GB

Member
Hi,
I have multiple workbooks, that when opened each workbook tries to link to an external source for updating.

What I am trying to do is to join these workbooks into one workbook, but before I do that I want to remove the link from each workbook. I know how to do this individually but not collectively. I assume this may require some vba? Appreciate your help.

regards
GB
 
Dear GB

If you want remove the data link from external source, then you can follow these below steps:
Click Data tab, edit links and remove/change source links.
 
vijay.vizzu said:
Dear GB

If you want remove the data link from external source, then you can follow these below steps:
Click Data tab, edit links and remove/change source links.
Click to expand...

Hi Vijay,
thanks but I was aware of this step per my original post. I have just found a way to do this. Go to File->Options->Advanced then scroll down until you find the "General" section then uncheck "Ask to update automatic links".

thanks
GB
 
You must log in or register to reply here.
Back
Top