Skip to main content

I have created a new report template in Excel but not all of my cells are populating?

If your Excel report template is only partially filling in, your System Preferences may be limiting how many Excel rows/columns Roof Wizard is allowed to process. Update the Rows/Columns to Process settings so they cover the full range of your template.

Updated over a week ago

The most likely cause will be the incorrect settings for the spread of cells in your spreadsheet.

To check the number of Rows & Columns in your template:

  1. Go to Set Up > Preference Settings > System Preferences (top menu of your software).

  2. Find the Excel processing limits:

    • Excel – Columns to Process

    • Excel – Rows to Process

  3. Check to see that your template’s required rows and columns don’t exceed the numbers set here.

  4. If they do, then you will need to change the numbers in this box so the processed range covers the full size of your template (where indicated below in your settings).

Did this answer your question?