Reference Manager Dialog

This tool is used to inspect details of inserted instances and manage references, etc.

Keyboard Command: XL2CADMG

Change Spreadsheet Procedure:

1. Select the rows to change using the selection area on the left (or use the select all button).
2. Click the Action dropdown, choose "Change Spreadsheet".
3. Optionally turn on the R (Relative Path) toggle button.
4. Click the select button ... to select the new spreadsheet file.
5. Click the Go button ✔ button to assign the value to the rows.
6. Click the OK button to make the changes to the inserts and have them update.

Notes:

• No changes are applied to the inserts until the OK button is clicked. So you may cancel at any time.
• The (R) Relative Path button must be set to the desired option before selecting the file.
• As you make changes to the data, the changed fields show with red text.
• The InsertName field cannot be changed with this tool. This is the CAD block name.
• The UpdateDate field cannot be changed and reflects the current spreadsheet file date, not the current date/time.
• Range names listed must also exist in the spreadsheet or they cannot be updated.

Details:

The buttons and sections of the dialog are explained below.

• Buttons:
  • Select All: Selects all the rows in the grid below.
  • Clear All: De-Selects all the rows in the grid below.
  • Information: Displays additional information about the (single) selected record. This information is based on the date in the inserts and does not consider any changes made to the record.
  • Delete: Deletes the selected tables. See next row for UnDelete.
  • UnDelete: UnDeletes all records that may have been marked for deletion in this editing session.
  • Launch: Opens Excel with the selected table loaded and ready to edit.
  • Zoom: Fills the drawing viewport with the selected table.
• List: A grid list of the referenced tables in the drawing.