Best practices

After you have generated a formula map from a source worksheet, do not change information the map requires for reference purposes. To enable the map to collapse and expand and show the data properly:

  • Do not delete or rename the dataset used by the source worksheet.
  • Do not delete or rename the source worksheet.
  • Do not change the data source used by the dataset to show member names or descriptions.
  • In the event any of the above actions occur, generate a new formula map.