MPCData formula contains invalid reference

If an MPCData formula that displayed a value at one time suddenly shows no value, it may be that one or more references in the formula have become invalid. These are two possible reasons for a formula not displaying a value due to invalid references:

• If a dataset is renamed or deleted after data has been inserted, when the workbook or worksheet is refreshed, the formula cannot return a value because it still references the old dataset name, which no longer exists. To resolve, insert the data again using the renamed dataset. Alternatively, you can replace the old dataset name in the formula with the new name to restore the value.
• If the data source has changed to show names instead of descriptions, or vice versa, after data has been inserted, when the workbook or worksheet is refreshed, the formula cannot return a value because it still references member descriptions instead of names, or vice versa. To resolve, insert the data again with the updated data source. Alternatively, you can replace the old member descriptions in the formula with the member names, or vice versa, to restore the value.