Analysis for office - Save changes before exit

[mhajek]

Hello,

We are currently developing some AO - based planning app for about 100 users.

Only one superuser has rights to actually modify the workbooks, the others just use them for planning and reporting purposes.

We also use one workbook as "redirecting", it just loads a query, opens another WB and closes itself.

And there our problem comes.

Is there any possibility to turn off the prompt that Analysis shows every time you try to close a Workbook "Do you want to save your unsaved modifications before exit" or so...

We don´t need it, users get confused and the redirecting workbook just won´t close without manually clicking "No" on this thing..

I haven´t found any Analysis setting, macro or so that could avoid it...

We are using version 2.7.1.

Any help is deeply appreciated.

MartinHájek

[mhajek]

Sad thing, but we stayed stuck with a simple message " Please close this workbook" instead of any real solution.

Martin