Appendix B - Troubleshooting - Quick Reference

Appendix B - Troubleshooting - Quick Reference

Common problems and solutions

Situation

Action

Cells are not yellow

Right-click → Why Can’t I Submit? Check: is the scenario selected? Is the period in range? Are mandatory filters set?

Submission rejected after first submission succeeded

The scenario dimensions are locked. Your current template uses different dimensions. See section 08.03.

An account has no row in the report

Use Add Missing Planning Rows (section 08.08).

Figures appear doubled when using a hierarchy

Submissions exist at both account level and node level. Audit and clean up (section 08.13).

Test data needs to be removed

Layout tab → Scenarios → Edit → Delete All Submissions. Or clear cells in Excel and submit. Sectiom 08.06

Workbook re-run breaks formulas in submission cells

Formulas are preserved only when the same row (same dimension combination) remains in the results. If a row disappeared, its formula is lost.

Contributor can’t open the report

The FastClose Excel Add-In must be installed. Check with IT.

Powered By