Custom Styles and Merged Cells in Forms

Excel formatting and custom styles are intended for use with static grids. When the grid contains merged cells, then changing the POV can result in invalid formatting. Other operations that can result in invalid formatting are:

• Changes to Suppression options

• Enabling or clearing the Repeat Member Labels options

• Adding members to the form definition

After any of these operations, if you encounter an error, such as "We can't do that to a merged cell" or invalid formatting with your form layout, try the following steps:

1. In the Planning ribbon, Formatting group, click Clear.

2. In the Formatting group, click Save.

3. Open the form on a new sheet.