🎓
Models University
  • Alpha Testing
    • 👋Welcome to Alpha
    • Installation and Setup
    • Support and Help
    • Terms and Licence
  • Start Here
    • What is Models?
    • Quick start
    • Tutorials
  • Using Taglo Software
    • The Taglo Interface
      • Navigating in Models
      • List Views
      • Adding Items
      • Deleting Items
      • Searching and Filtering
      • Previewing and Editing
      • Using Wizards
      • Save/Undo/Redo
      • Keyboard Shortcuts
    • Data Storage
    • Namespaces
    • Inbuilt data
  • Tags
    • Introduction to Tags
    • Tag Basics
    • Tags Applet
    • Advanced Tags
  • Models
    • Home Tab
      • Creating a Model
        • Timings
      • Version History
      • Application Settings
    • Model Editor
  • Variables
    • Variable Basics
      • Variable Setup
      • Unit and Calculations
    • Time Segments
      • Time Segment Setup
    • Summaries
    • Default Assumptions
  • Units
    • Introduction to Units
    • Key Unit Concepts
    • Advanced Units
    • Defining a Unit
    • Unit Factors
  • Dimensions
    • Introduction to Dimensions
    • Dimension Setup
    • Defining Unit Variance by Dimension
  • Data Types
    • Data Types
  • Assumptions
    • Introduction to Assumptions
    • Creating/Referencing Assumptions
    • Assumptions Wizard
      • Assumption Dates Step
      • Assumption Values Step
      • Linking to external Data
      • Linking to Excel Inserts
      • Sensitivity Values
  • Calculations
    • Introduction to Calculations
    • The Calculation Page
      • The Formula Entry Bar
      • Unit Analysis
    • Calculation Parts
      • Variable References
        • Referencing Time
        • Referencing Dimensions
        • Lookups
        • Summarising Variables
      • Period References
      • Functions
        • Advanced Functions
  • Aggregation
    • Introduction to Aggregation
    • Creating Aggregations
  • Rearranging
    • Introduction to Rearranging
    • Rearranging Example
    • Rearranging Tips
  • Cases
    • Introduction to Cases
    • Managing Scenarios
    • Managing Sensitivities
  • Layout
    • Generating Excel
    • Auto Layout
    • Sheets
      • Sheet Content
      • Adding and Editing Content
    • Excel Formatting
      • Excel Themes and Styles
      • Line Formatting
    • Data Tables
    • Excel Generation Troubleshooting
  • Excel Inserts and Outputs
    • Excel Inserts
    • Excel Outputs
  • Number Formats
    • Number Formats
  • Dashboards
    • Dashboards Basics
    • Dashboard Layout
    • Dashboard Items
    • Excel Dashboards
  • Metrics
    • Metrics
  • Charts
    • Introduction to Charts
    • Chart Customisation
  • Importing Models
    • Importing Models
  • Data
    • Introduction to Data
    • Creating Data
    • Data Sources
Powered by GitBook
On this page
  • Overview
  • Known issues
  • Tips
  1. Layout

Excel Generation Troubleshooting

Tips on what to do when Excel generation doesn't go as expected

PreviousData TablesNextExcel Inserts

Last updated 1 year ago

Overview

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 .

Known issues

Issue
Details

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

Tips

If the generation process is causing errors, or not working as expected, you can try the following:

Action
Details

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.

support@taglo.io
Plug-In
support@taglo.io