I was wondering if it was possible to deactivate the update links in Excel 2007 by default.
The same way it can be done in vba when you are opening a file (workbooks.open path... updatelinks:= False)
Ok you change the parameters to always ask you if you want to update the links, but the problem is that I have a file where I can't find the cell with the links that point to a unknow location. So it take a while to open the file.
I have created a macro to open the file without updating links but I would like to have it standard in Excel.
Thanks