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 row(s) 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 row(s).
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 of the dialog are explained below.

• ☑: Selects all the rows in the grid below.
• ☐: Unselects all the rows in the grid below.
• ⓘ: 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.
• ×: Deletes the selected tables.
• ←: Restores all records that may have been marked for deletion in this editing session.
• ▦: Opens Excel with the selected table loaded and ready to edit.
• 🔍: Zooms the drawing viewport to the limits of the selected table.
• 🖶: Sends the current records to a HTML document and your browser.
• A: Sends the current records as a CAD Table.
• x: Sends the current records to Excel.
• w: Sends the current records Word.