I have links to a spreadsheet that also contain automatic refresh of essbase
data,

I have prevented the update links from appearing when the spreadsheet is
open but when it goes to the essbase retrieval sheet the update links message
comes up

any way to prevent this happening