Skip to Content
Former Member
Apr 29, 2014 at 11:13 AM

crosstab disconnected from data source


Hi There,

Just recently, few users have reported issues where the crosstab is disconnected from its data source. Therefore, when data source is refreshed then it doesn't refresh the sheet with crosstab. In the following example, crosstab1 on "Production BI" sheet is connected to data source but rest of the sheet has lost it's crosstab connection to data source. However, I can still see all the data sources in the prompt window.

We are using following

> Analysis for Excel - Version 1.4 SP6

> Excel 2013

Is there anyway that we can re-assign data source to crosstab without creating a new sheet with new crosstab and data source? Any help will be highly regarded.