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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply