The worksheet inspector

The worksheet inspector provides quick access to firesys-relevant information relating to your Excel worksheet. It docks itself to your Excel document as a work area. By default, the worksheet inspector opens automatically with your firesys document. You can disable this function in the Settings.

<imagemap>Datei:EN-Excel Status Menüband-Blatt-Inspektor.jpg|1200px|center rect 3 85 219 203 Die_Basisfunktionen_von_firesys rect 224 85 511 202 Das_StatusCockpit rect 515 85 593 201 Der_Blatt-Inspektor rect 597 86 721 202 Farbige_Markierungen_in_Excel rect 725 86 800 200 Der_Blatt-Navigator rect 802 85 885 200 Der_Blattstatus rect 890 83 1108 201 Die_Vorrollen-Funktion

desc none </imagemap>

An overview of the functions of the worksheet inspector

You can use the worksheet inspector to identify errors or inconsistencies in a practical overview by using coloured icons and overview lists showing additional information.

Below is a list of all parameters that are checked: 

Excel file

File name

The file name of the Excel file that is currently open

Save date

The date when the currently open Excel file was last saved

Calculation options of the workbook

Displays the calculation option that is selected in Excel for the current workbook. You can change the setting in the “Calculation” group in the “Formulas” Excel ribbon

Hidden worksheets in the workbook

This icon is displayed if your workbook contains hidden worksheets

Worksheet

Name

The name of the currently open worksheet

Used range

The range of the current workbook in which you have defined ranges is displayed here. If you have defined several ranges, the ranges are summarised.

Print area

The range of the current workbook that you have defined as the print area is displayed here.

Status

The current status of the worksheet

Rolled forward

The file name of the currently open Excel file

Worksheet protection

Hidden rows

Hidden columns

Excel errors

Cells with “####”

Validation

Number of validations

Validations with deviations

Defective validations

Dictionary

Cells with translations

Missing translations

	Good to know
	Information that is not relevant remains hidden in the worksheet inspector. If you are not using any validations or translations on the current worksheet, these elements are not visible.

Settings

The view of the settings in the worksheet inspector

You will find the settings for the worksheet inspector in the second tab in the menu ribbon.

General

Start after activating firesys

You can close the worksheet inspector at any time and use this function to configure that the worksheet inspector is no longer started the next time firesys is activated.

Read out information

The worksheet inspector displays the information shown above from various firesys components. This information can also be read out dynamically.

Read out when changing the worksheet

If you select this option, another settings level appears in which you can define which information should be read out dynamically and displayed in the worksheet inspector. The following options are available:

• Dictionary and validation cells
• Hidden rows and columns
• Cells with Excel errors
• Narrow columns (###)

	Good to know
	The worksheet inspector display may vary depending on which options you selected.

See also

The worksheet status in Excel
The StatusCockpit
The worksheet navigator
The worksheet status in Excel
The rolling forward function
Coloured highlighting in Excel

Further contents

→ firesys website
→ Customer area
→ YouTube