Getting the below error after extracting the macro as excel sheet

[Gautham A]

I do certain operations in macro sheet and i extracted it as a separate excel sheet. After opening the excel sheet, im getting the below error.Is there any code i can wrote in VBA to disable the below error?



We can't update some of the links in your workbook right now.
You can continue without updating their values, or edit the links you think are wrong

 

[mrshl9898]

Tried turning alerts on and off?

application.displayalerts = False
application.displayalerts = True

 

[Gautham A]

Yes. I tried that one as well. The issue here is not with the macro sheet. The error comes after I extract some of the sheets in this macro as a separate Excel file.

 

[MARK858]

Not sure if it will work in your case but maybe try....

Sub Workbook_Open()
   Application.DisplayAlerts = False
   Application.AskToUpdateLinks = False
   Application.DisplayAlerts = True
End Sub

Another option (although I don't like using it) is

Private Sub Workbook_Open()
ThisWorkbook.UpdateLinks =  xlUpdateLinksUserSetting  'or  xlUpdateLinksNever 
End Sub

 

[Gautham A]

Hi Mark,
The second one works in my Excel sheet. Thank you so much

 

[MARK858]

You're welcome