Skip to Content
May 23, 2018 at 07:29 PM

Analysis for office get disconnected when Save/Open Workbook with Chart


Hello AFO expert,

I have created a Chart from analysis for office (Version The Chart is dynamically get update with the report as long as you connect directly to the Data source. However, as soon as you save/close the Workbook and re-open it, when you refresh the DataSource, the workbook/report get disconnected and you see the report throwing an error (Datasource assignment not complete) and the Chart obviously it not dynamic anymore since the source data come from the report. I also, want to emphasize that this occur whether you have the Chart on the same or different sheet than the report in the same workbook.

Workbook or report without Chart are working properly, so I believe including the chart is creating all this problem.

Please let me know if you encounter the same issue and how did you resolve it.