Good afternoon,
I have a PowerPivot workbook that is pulling info from an SQL view. I can refresh the table, but the measure at the bottom is not recalculating with the refreshed data. There are about 10,000 rows in the table returned. It is linked to another SQL table with just info and an Excel linked table with just info. If I change the measure, then it will recalculate. I have tested that the info is correctly pulled in by copying it to a workbook and totaling it. I checked and PowerPivot is set to AutoCalculate. The measure is a simple one - just a sum of the column created using the Autosum option on the Calculations menu item.
I've had this happen a few times in other workbooks as well. Any ideas on why this is happening?
Thanks,
JNM
I have a PowerPivot workbook that is pulling info from an SQL view. I can refresh the table, but the measure at the bottom is not recalculating with the refreshed data. There are about 10,000 rows in the table returned. It is linked to another SQL table with just info and an Excel linked table with just info. If I change the measure, then it will recalculate. I have tested that the info is correctly pulled in by copying it to a workbook and totaling it. I checked and PowerPivot is set to AutoCalculate. The measure is a simple one - just a sum of the column created using the Autosum option on the Calculations menu item.
I've had this happen a few times in other workbooks as well. Any ideas on why this is happening?
Thanks,
JNM