Hide Update Links Message - Different than other threads!

**DieHard64** · 03-11-2013, 12:40 PM

Hi guys,

I'm opening an excel workbook from a batch file and I've got some code in the Workbook_Open statement. However, Excel keeps asking whether I want to update the links (which I don't want to for this workbook).

Answers I find on the internet that do NOT work in this case:
- Workbook.Open statement changing the UpdateLinks parameter => my workbook is already open, I don't open it again or from another Excel file
- Changing properties in Options => I need my other Excel workbooks to still ask it, I'm looking for coding here
- Application.AskToUpdate = False => Does not work because the workbook somethimes has links that cannot be updated and then Excel prompts that error message (which I don't want it to)

Thanks!

**DieHard64** · 03-12-2013, 05:12 AM

I think I once read you could tell Excel its links are up to date (regardless of whether they really are). That should be some easy property to set somewhere (boolean type), but I cannot find what it is.

Can anyone help?