Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

Stop file from linking

Hi,

I have a file with many links in it. Is there any way on opening, i cant stop these links from automatically updating

I know i can use
UpdateLinks:=xlUpdateLinksNever


Im not sure where to put this, the links are spread over several sheets

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
  • 4
  • 3
1 Solution
 
SiddharthRoutCommented:
Yes . Which Excel Version do you have?

Sid
0
 
SiddharthRoutCommented:
I was planning on giving you a non VBA method but if you want a macro then paste this code in the workbook open event.

Private Sub Workbook_Open()
    ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
End Sub

Open in new window


This will apply for all links in that workbook.

Sid
0
 
Seamus2626Author Commented:
2003
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
SiddharthRoutCommented:
I have already given you the Macro code but here is the Non VBA Method.

If my memory serves me right then in the menu EDIT>>LINKS>>STARTUP PROMPT there you have options on how to suppress the startup link update message.

Sid
0
 
Seamus2626Author Commented:
That never worked Sid, i have uploaded a screen shot of the file hanging

I can get into the file if i use the Document Recovery.

Im wondering is it definately the linking issue?

Thanks
Seamus
Doc4.doc
0
 
SiddharthRoutCommented:
Are macro enabled?

If macro are disabled then that 'hanging' could be because of links getting updated...

Sid
0
 
Seamus2626Author Commented:
All sorted, thanks Sid!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now