Excel Generation Troubleshooting
Tips on what to do when Excel generation doesn't go as expected
Last updated
Tips on what to do when Excel generation doesn't go as expected
Last updated
If Models or Excel encounters a problem when generating Excel, you will be shown an error or warning message in Models with details of the issue.
If this message does not provide you sufficient information to fix the issue yourself, please contact us at .
Slow Excel generation due to offline printer
In some rare cases, Windows sees an offline printer as being connected. If this printer is the default printer, this will cause a significant delay during Excel generation due to Excel attempting to access printer's available fonts during formatting. Fix: Remove offline printer from list of printers, or set a different printer to default
Failure due to Plug-Ins with duplicate Named Ranges or Lambdas
If a has Named Ranges or Lambdas with the same name as in the sheets generated by Models, this can cause a failure. Fix: Remove or rename conflicting Named Ranges and Lambdas
If the generation process is causing errors, or not working as expected, you can try the following:
Refresh Models
Press F5 to refresh your Model. This can sometimes solve issues with Excel generation (if this is the case, we'd appreciated it if you emailed us at with details of any error messages received)
Close all Excel instances
Problems can be caused by unclosed background instances of Excel. Models should never leave any instances of Excel open, but it can happen in rare cases, and Excel itself can leave background processes running. You can manually close background Excel processes in Windows Task Manager, or use Models to do so by navigating to Menu > Excel > Close background Excel. Make sure you close/save any work in Excel before doing so.