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.