1

I have several workbooks which use CUBE functions which reference the Data Model. Up until recently these always worked fine; now, however, after performing a full refresh of the queries which feed the Data Model, all formulas containing a CUBE function remain stuck, displaying #GETTING_DATA within the cell.

No VBA is incorporated and all queries within the workbook have Enable background refresh disabled.

The formulas can be forced to resolve by performing one or more (one is not always sufficient) full workbook recalculations, though this is clearly not ideal.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.