Jim,
Could you give me an example please

"Jim Thomlinson" wrote:

You have to check the value of the retain on retrieval setting prior to
trying to make the switch. Retain on retriveval must be set to false, or you
can not make the change.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

I am trying to set the option to set suppress missing rows and suppress
zero's to on a spreadsheet and am using the following

EssVSetGlobalOption , 6
EssVSetGlobalOption , 7

but this does not work, what do I use to turn these options on and then turn
them off

Thanks