Excel cannot convert to formulas because one or more filtered fields are not completely visible. To make the filtered fields ...

Excel cannot convert to formulas because one or more filtered fields are not completely visible. To make the filtered fields completely visible, do the following:

• Expand the entire field for all fields above the filtered fields.
• If grand totals are displayed, display the subtotals.
• Try to convert to formulas again.