I have a formula in a ss linked to another file
=COUNT('G:\Asset Services Risk Team\Cash Nostros\[Asset Services Outstanding Cash Items.xls]Outstanding Items Report-1'!$H:$H)
As my Macro goes through, a screen comes up saying "Update Values" and tries to direct me to the file and press ok.
How can i surpress this error message?
I have put code to always update links on workbook open, but it is still looking for me to update those values
I have atatched a screenshot of where it makes me update values