Skip to Content
Author's profile photo Former Member

Problem: Reverting user Number Formats to query Number Formats

Analysis lets users define custom Number Formats on individual measures, but there doesn’t seem to be a way of reverting a measure (or the entire Crosstab/DataSource) to use Number Formats defined by the Query.

The user can change the measure’s Number Format to “Default”, but “Default” is not necessarily the Number Format defined by the Query. The user can also apply a variety of other Number Formats, but there’s no way to determine which Number Format was originally stipulated by the Query.

Restarting (via VBA) / Refreshing the DataSource doesn’t seem to clear any user-defined Number Formats, so the only apparent way of reverting to Query-defined Number Formats is to delete, and reinsert the Crosstab.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.