Analyze In Excel has been unreliable yesterday and today. In workbooks regularly used each week without issue, many cube values now produce #N/A's, yet return values when changing seemingly unrelated...
mikegunns
Helper I
Helper IHi Quiyun,
Thanks for taking a look. We are still having the issue today. The data sources used in our dataset are an Excel file on Sharepoint, and Salesforce.
It is difficult to explain how you might reproduce the issue because it is so unpredictable. For example where all the CUBEVALUE functions shown in the screenshot produce #N/A, changing or deleting one of cells may all of a sudden cause the other cells to work and correctly return values. When trying to rebuild the same spreadsheet in a brand new workbook with a new .odc file (we have tried several times with several of our workbooks), we can only get so far with all cube functions working, then it seems to hit a "critical mass" when we add just one more CUBEVALUE function, and at that point all or most of the previously working functions then fail.