On the Essbase menu Select Options- Global tab and change the Warning
settings. These settings can be changed through code also if you wish. They
are global settings (as opposed to sheet level settings) which will be in
effect for every retrieve that you perform on every sheet.
--
HTH...

Jim Thomlinson


" wrote:

When retriving Essbase using macro, if there are other text in the
sheet(other than the essbase's own formatting), warning msg will pop-up
everytime. Is there any ways to disable these pop-ups which will
disturb the retrieving? Tks!