Hello,
I built a pivot table with several measures that key off a single date, for which I created a disconnected table on a tab in my workbook with one column and a single date value. The purpose being, I update that one date periodically based on the period I want to evaluate. Probably a better way to do this, but when I first created the report everything worked perfectly.
Now, when I update the date in that table and try to refresh, I get the following error message:
"The command cannot be completed. No tables were detected in the active Excel workbook that are linked to PowerPivot tables."
For reference, an example of one of the measures I'm using is as follows. Worked fine when I first set it up.
Future Past Due Balance = calculate([Total AR Balance],FILTER('Aging','Aging'[Due]<=MAX('Date'[Date])))
No matter what I try, I can't get this table to refresh. If I refresh all from the power pivot window, all tables update but this particular table isn't shown. If I try "update all" from the tab itself, I get the above error message.
Any thoughts on how to correct this issue would be much appreciated!
Thanks!
I built a pivot table with several measures that key off a single date, for which I created a disconnected table on a tab in my workbook with one column and a single date value. The purpose being, I update that one date periodically based on the period I want to evaluate. Probably a better way to do this, but when I first created the report everything worked perfectly.
Now, when I update the date in that table and try to refresh, I get the following error message:
"The command cannot be completed. No tables were detected in the active Excel workbook that are linked to PowerPivot tables."
For reference, an example of one of the measures I'm using is as follows. Worked fine when I first set it up.
Future Past Due Balance = calculate([Total AR Balance],FILTER('Aging','Aging'[Due]<=MAX('Date'[Date])))
No matter what I try, I can't get this table to refresh. If I refresh all from the power pivot window, all tables update but this particular table isn't shown. If I try "update all" from the tab itself, I get the above error message.
Any thoughts on how to correct this issue would be much appreciated!
Thanks!