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

[Former Member]

Hi Martin,

Look at that Microsoft link,

suppress-save-changes-prompt-when-you-close-a-workbook-in-excel

Regards

Eric

l

[mhajek]

Thank you, but the problem is not Excel, but Analysis. Without the Analysis query, the workbook quits without asking (thanks to some simple macros), but analysis plug-in always asks to save the analysis workbook anyway.

Martin