System Defaults

This dialog controls system settings. All settings are stored in the Windows registry.

Keyboard Command: XL2CADDE

The sections of the dialog are explained below.

• Update Linked Annotations on Drawing Open: When enabled, any Annotation Links will be updated (subject to Known Limitations).
• Update Spreadsheets with Linked Expressions: When enabled, any Exported Expressions will be sent to the linked spreadsheet (subject to Known Limitations).
• Update Objects on Drawing Open: Turn on this toggle to have XL2CAD check the documents when the drawing opens (subject to Known Limitations). After the drawing opens, XL2CAD looks at each document and compares the time it was created with the time the referenced document file was last saved. If the time difference is within the limits of the Save Delay (below), it is skipped and this is echoed to the Command prompt. This speeds up the opening process by not wasting time updating documents that are already up to date.
• Update Xrefs Containing Links: Turn on this toggle to have the application scan XREFs for tables that need updating.

  Note: The application uses a secondary session of CAD to update these drawings and MDI must be enabled.

  Unlike CAD, XL2CAD will not attempt to hunt down the xref drawing. If the file does not reside in the stored path, it will not be updated.

• Close 'No Document' Excel Sessions: When enabled, any Excel sessions that do not have a workbook in memory will be closed.
• Save Delay: This is the amount of time (in minutes) that should be accepted as the save delay. When XL2CAD creates a document in the drawing, it stores the creation time and the filename on the insert. It then creates a named range in Excel.

  Rather than saving your document in code (which you may not want), this tool expects you to save the document yourself after the document is created. Most people will do this within 1-2 minutes of completing the document. As such the default delay is 5 minutes. This means if the document is saved within 5 minutes of document creation, it is assumed that no changes were made and the update should be skipped.

  Opening the document several minutes (or hours or days) later will make for a large time difference and cause an update when the drawing opens.

  Note: Failure to save the document after placing the document will prevent XL2CAD from being able to update it later.