PDA

View Full Version : Solved: open file without links



philfer
03-16-2008, 11:56 AM
I am having a sheet sent to me by email from abroad.

When I open it it says do I want to update links. However I cant as I dont have access to their server. When I try to break the links it gives me errors instead of just values

Is there any way I can just open this file with just values and break all the links

Simon Lloyd
03-16-2008, 12:13 PM
perhapsWith ActiveWorkbook
.UpdateRemoteReferences = False
.PrecisionAsDisplayed = False
.SaveLinkValues = False
End With
Application.AskToUpdateLinks = Falsebecause to break links i think you need to know the link name and type!