Last Modified Date: 19 Dec 2019
Scenario 1: Calculated Fields DisappearTry one of the following options
- After replacing the data source, copy and paste the calculated fields from the original data source to the new data source.
- Before replacing the data source, make sure all calculated fields are included in at least one worksheet.
Scenario 2: Calculated Fields Are Marked Invalid
Try one of the following options
- Replace Field References to the correct field. For additional information on replacing field references, see Replace Field References.
- Use a data source that supports all functions that are used in the calculation (extracting the data is an option).
CauseIf calculated fields have disappearred: only calculated fields that are used are transferred to the new data source to help prevent clutter.
If calculated fields are marked as invalid: there are two reasons why a calculated field can become invalid.
- A field from the original data sources does not exist (including but not limited to changing the name of the field) in the new data source.
- The new data source does not support all functions that are used in the original data source.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials