Check References

Available from Version: -

Operating System: Windows

empower® Add-in: Brand Control

Depending on the complexity of the content to be displayed in a workbook, references to other data sheets or separate workbooks are often used. With empower®, all these internal and external links to data sheets or separate workbooks can be checked for their functionality in an open workbook. All valid and invalid references are detected.

A reference is considered invalid, if:

  • a workbook is referenced (either stored locally or in the library) that has been deleted after the reference was created.

  • a workbook saved to the empower® Library is referenced that has been closed after the reference was created.

  • a data sheet is referenced that has been deleted after the reference was created. This applies both to data sheets within the open workbook and to data sheets from other workbooks. The workbooks can be either stored locally or in the library.

  • a workbook with a file format that is not supported by Excel is referenced.

You can then manually edit and correct invalid references.

To check and correct references, follow the following steps:

  1. Navigate to the group Finalize and click on the button References (Figure 534, “Button References”).

    The check is automatically started.

Figure 534. Button References

Button References

  1. An overview opens via the side pane, displaying all existing references, sorted by the categories Internal and External.

    If one of the references is invalid, it is marked with a X symbol (Figure 535, “Reference Overview”).

Figure 535. Reference Overview

Reference Overview

  1. Click on one of the references to navigate directly to the data source in the workbook.

    The linked data will be selected accordingly.

  1. Switch the toggle button Show only broken references to On, if you want to focus on all invalid references (Figure 536, “Toggle Button Show only broken references”).

    The overview is filtered accordingly.

    References and formulas inserted on hidden datasheets are also taken into account and recognized by the check and listed in the overview (Figure 537, “Invalid References Only”).

  2. Manually correct any invalid references that are found.

Figure 536. Toggle Button Show only broken references

Toggle Button Show only broken references

Figure 537. Invalid References Only

Invalid References Only

To refresh the overview after making changes, click on the refresh symbol to the left of the X symbol in the open overview (Figure 538, “Refresh Symbol”).

Figure 538. Refresh Symbol

Refresh Symbol

You also have the option to refresh all references in your workbook using the Excel built-in functions directly in the empower® Ribbon.

To do so, use the options under the split button Refresh in the group Finalize.

These options reflect the Excel built-in options available in the group Queries & Connections in tab Data.

For further information regarding the Excel built-in functions, see Refresh an external data connection in Excel.

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.