Skip to Content
Aug 25, 2020 at 02:05 PM

How to suppress the message: "Plan data not saved." when closing a workbook?


Hello together,

When you close a Analysis for Office Planning Workbook in Excel and have changed some data you receive a message "Planning data not saved. Do you want to save the data."


I am looking for a solution to suppress this message and handle the case differently.

I know the VBA Event "Workbook_BeforeClose" but so far I did not find a solution to know that this message is active and to suppress it because it's not shown in the "SAPListOfMessages".

Has anyone an idea?

Best regards


data-not-saved.jpg (15.0 kB)