I hope you can help me with my problem with the Analysis for Office AddIn in Excel (2.7 SP4 or 2.7.400.87314) in one of our customer environments.
I am trying to save a workbook with a linked query on the BO server. The query-provider does not own any data and the query-option "Remove data before saving" is activated. While trying to save, I receive a nested exception with the description "Object reference not set to an instance of an object". Unfortunately, the error window does not show more details.
We urgently need this constellation with the "Remove data before saving" option, because the query variables that are displayed in the worksheet should also be empty while opening the workbook.
We reproduced this error in another environement with 2.7 SP4 (different version of excel ans also a different version of the BusinessObjects server). After updating to SP5, the error disappeared. But in my case it will not be possible to update AfO to SP5.
Does anyone of you have experiences with this error and perhaps found a solution (SAP Notes etc.) ?
Thanks for your support