Dataset not reloaded

If you add members from an existing dataset, you must navigate from the Dataset tab to reload the dataset. If you do not navigate from the Dataset tab, any existing data in the workbook continues to use the unrevised version of the dataset.

Consequently, if you added a member to the dataset and then manually typed in the new member on the worksheet data area or in the MPCData formula with the Dataset tab still open, no data would display on the worksheet because you have not yet reloaded the dataset to make that member available. To show the data, first click another tab to reload the dataset and then change the member on the worksheet. Alternatively, you can refresh the workbook data.