THe links are new, I have a sheet that is calculating the holidays for this
year and last year, since I have multiple reports that run, I was hoping to
only have to update one workbook and link that to other workbooks,


In this case I have to go to multiple essbase sheets and retrieve data onto
them, the workbook opens correctly but as it scrolls thru the worksheets then
it wants to update again, I was hoping to get rid of that annoyance

"Jim Thomlinson" wrote:

You are a little thin on details... First off are the links in your
spreadsheet necessary? It sounds like you are dismissing the update. Is your
code taking you to the essbase retrieveal sheet? If so you do not need to
select the sheet. A retrieval can be done to a non active sheet. Only a lock
and send requires the sheet to be active (which is mighty annoying)...
--
HTH...

Jim Thomlinson


"Nigel" wrote:

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