New or Modify Excel Data Link dialog box |
|
Depending on how you accessed this dialog box, you can use it to create a new data link or modify an existing data link. DIALOG BOX OPTIONS Name Enter a name for the data link. Choose an Excel File Displays a list of Excel files that are referenced from the current drawing. Select a file from the list, or click [...] to browse for another .xls, .xlsx file that you want to use for creating a data link. Path Type Choose whether you want to use a full path, relative path, or no path to find the specified Excel file. Select Excel Sheet to Link To Choose the sheet from the list of all sheets contained in the specified file that you want to link to. Link Entire Sheet Select to create a link to data in the entire specified sheet within the Excel file. Link to a Named Range Select to create a link to data from a named range of cells within the Excel file. Available only when the specified file contains named ranges. Link to Range Select to create a link to data from a custom range of cells. You can specify an entire column (e.g., A:A), a set of entire columns (e.g., A:D), or a rectangular area (e.g., A1:D10). When this option is selected, the Update Preview button is available. Update Preview Click to update the preview of the data after a range of cells is specified. Preview Displays a preview of the referenced data using the specified options. Tell me about... |
![]() |
© Copyright 2023. Back2CAD Technologies LLC. All rights reserved. Kazmierczak® is a registered trademark of Kazmierczak Software GmbH. Print2CAD, CADdirect, CAD.direct, CAD Direct, CAD.bot, CAD Bot, are Trademarks of BackToCAD Technologies LLC. DWG is the name of Autodesk’s proprietary file format and technology used in AutoCAD® software and related products. Autodesk, the Autodesk logo, AutoCAD, DWG are registered trademarks or trademarks of Autodesk, Inc. All other brand names, product names, or trademarks belong to their respective holders. This website is independent of Autodesk, Inc., and is not authorized by, endorsed by, sponsored by, affiliated with, or otherwise approved by Autodesk, Inc. The material and software have been placed on this Internet site under the authority of the copyright owner for the sole purpose of viewing of the materials by users of this site. Users, press or journalists are not authorized to reproduce any of the materials in any form or by any means, electronic or mechanical, including data storage and retrieval systems, recording, printing or photocopying.
|