I want to know if you can link AutoCad tables to other Autocad tables on different layouts. Say I have ten sheets, each with a table for quantities of pipe length, and one sheet with a total of all quantities. Can I link cells from each separate layout sheet to the main table sheet, so that I can add them all for project totals?
View 3 RepliesWe have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
Is there a way to force the table and table text height to stay constant despite the scale? I can do it for Point Label Styles with an Expression. But in 2011 there is no way to build an expression for a table style.
I want to create tables in the drawing where the points are and then plot them from a drawing they're Xrefed in to. The tables are too small but zooming in doesn't make them any bigger because the scale of the viewport changes and they adjust.
I would like to read a table that would be linked with block attributes. Like a table (either AutoCAD or Excel) of fluids with pressure, temperature, flowrate... that I would link to attributes. I tried to insert a field in the attribute, but what I've found in fields are properties like Color/Layer/Column/Rows ..
View 4 Replies View RelatedIs there any command in autocad to LINK TEXT TO SCHEDULE TABLE. I have door & windows in my plan I have given attribute numbers to them as per sizes like for
800mm -w1
900mm-w2
1200mm-w3 etc...
I have made window opening schedule table , when ever i add or delete one window form schedule i have to change the order. like if i delete 900mm window schedule will be.
800mm- w1
1200mm- w2 etc....
so I am looking for a command when ever i change my schedule table my attribute numbers should also change.
Is there any way to do this in Autocad? Split a table so it is in 2 sections side by side, rather than one verrrrrry long one? Similar to what you can do in Inventor?
[URL]
I have a situation where I just created brand new drawing templates and they have the revision block inthem already. The revision block that comes with Inventor. The vault is driving the revision in the titleblock and when the revision is placed in the revision block it too is linked to the vault. When the drawing is checked into the vault and the lifecycle is changed to "Released" and then back to "WIP" the revision updates. Both in the titleblock (which I want) and in the revision block which I don't want. Not only is it change the revision block, but the last revision posted as per the image below.
how do I change the property in the settings of the title block to not get it's revision from the vault or allow it to be manually driven?
I am trying to insert a table using a data link. I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen. When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.
View 6 Replies View RelatedUsing AutoCAD 2010 LT with service pack 1 and 2
I created a link to an Excel file to create a table. Before I ETransmit the AutoCAD file (along with many other files) I want to remove the link so that the table is embedded with no need for the external file. When I have somebody who doesn't have the linked file on their machine open the file they get a "missing external file" message" despite the fact that I ran the detach data link command and have purge selected in the ETransmit setup. The table shows up with the data, but I want to eliminate the nag pop up about the missing file. I know you can click the ignore button, but I don't want our customer to have to bother with it.
Any way to save a list of files for ETransmit like you do in a .dsd file for batch plotting?
The angle or radius are outside the table boundaries. I have used bend tables before and have not run into this. See screenshot. What I don't understand is that in the error dialog box the Thickness is correct the Radii are correct and the Angle is correct except it is showing a -90 degrees. Is that the problem? The negetive? Why is it showing a negative number. I can't change the way the part is formed. The problem seems to be with the lower left hand curl. It does go ahead and flatten it, but I don't trust the results when I have the three errors.
View 1 Replies View RelatedIn our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014
Inventor 2012 SP2, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
I have a table linked to an Excel spreadsheet, I unlock the cells and then right click but the Data Link sub-menu is greyed out and not available. Cannot delete the link in the data link manager becasue it is in use. Had to open the drawing in 2011 and detach the data link. 2008 also detached the link no problem.
How to detach a table link?
How to fix a broken link to an excel table in an idw file general table?I changed the folder name and heirarchy of the project.i expected the idw tables to find their parent excel files in the same folder with a new name, but they didn't.
I could find nothing for fixing broken excel links.
I have created a table style in ACAD 2012 with all of the cells formatted to what I need. The trouble begins when I bring in a BIAS excel data link to populate the table. I have tried every option in the insert table steps and have even tried all the different options under the modify excel link options. I have toggled the use excel formatting on and off, which does change the table size a small bit, but does not allow the table style to take affect.
I have attached a screen shot of the "good" and "bad" tables. The bad table is what the good table comes in as and it is also what happens everytime the table link updates. It always reverts back to the bad style and then I have to change the table back to the good one by hand - changing each column individually.
Is there a way to attach a data link to a table with the table style holding its shape and formatting?
This happens on all of my drawings and using all kinds of different excel links.
how to bring in the data link??
I have created a simple iPart that has three length variations, and therefor has three different surface areas.
I have added a simple table to my drawing. The table is linked to the iPart, I have used the column chooser to select the appropriate parameters to illustrate the length variations from the iPart. I would also like to include the surface area for each iPart member alongside each length variation in the table.
I have several drawings with tables on them with broken links to spreadsheets which have been deleted.I can't edit the tables.
Is there a way of reusing the information in the table to recreate the spreadsheets or new tables.
we recently were trying to import an excel table via data link function. Initially this works fine and the table appears in the drawing however when we want to break the link by deleting it in the data link table autocad tells me that the link is in use. We routinely do this in autocad mechanical 2010. The reason we do this is to be able to bring in the table and preserve formatting. How can we easily delete the data link in 2010 LT?
View 9 Replies View RelatedI have a part where I have placed a number of table driven iFeatures. These features generate parameters in the model that I can see in the parameter table. I am trying to find a way to have these iFeature parameters show up in the hole table in my drawing.
By 'exporting' the parameters, I have been able to get the values to show in notes and drawing view labels but I can't find a way to add them as a 'New Property' in my hole table.
Having an issue trying to join an access table to a shp file attribute table. I want to use the access table to cross reference the shp file for matching parcel numbers. I have attached the access table in the ODBC using a data source name however it seems to not give me the option to view any records.
View 2 Replies View RelatedI am wanting to use an Autocad table object to display fields from an Access database table that is linked to symbols in my drawing.
My objective is create a database table that has detailed notes for call outs in my drawings and then link my call out blocks to the database table and display the blocks and linked descriptions in an Autocad table. If the notes in the database table are edited the Autocad table updates with the new the description from the database.
How can I export a excel table to Autocad not as an OLE object but as a Audocad table?
View 7 Replies View RelatedI struggled for a while this morning with trying to data link to a large door schedule in Excel. After several failures, I searched online for answers, and read in another forum that AutoCAD won't data link to more than 2000 cells.
My door schedule is about 2050 cells now, and will be about 4000 when done. I defined a set of about 1,000 cells in the Excel spreadsheet, and AutoCAD linked to it no problem. So, I tend to believe the poster who stated the 2000 cell limit, but I can't find this.
Say I had two tables located within AutoCAD, can I make it to where if I put data in one cell of one of the tables that it could automatically populate in a different cell in the other table? Also if this can be done, could it be done linking the data in-between separate layouts?
View 9 Replies View RelatedSo I just upgraded to MEP 2013 last week and am in a bad situation where when I keep making my data link tables to a range on an excel table the file name's full address is not staying when I go to insert the table.
(ex. D:/Documents/JB Plans/NK.xlsm is just NK.xlsm when I try to insert the table)
Does some defaulting or setting that I haven't found involving this issue?
I am repeatedly running into the same problem of a data linked table losing its formatting upon closing and opening the file.
Each time this happens, I am forced to enter the properties tab and return the height of the text and the height of the cell to the size that it had originally been. Is there an option that I have not seen? What is continuously causing this error?
Is there a way to setup vertical alignment of text in a cell for the entire table, when using Table Tool? It is possible for a single cell, but when selecting a table (or multiple cells) this option is not available.
View 5 Replies View RelatedCreating a CTB file to mimic a Microstation pen table? I have a client supplied *.tbl (an intergraph pen table file I believe) and how to generate a CTB that will behave similarly (ie. plot nearly the same)..
I can open the *.tbl file in a text editor and it just looks like a bunch of "if, then" statements related to line weights and pattern files....
I have already created a template with the same layers/levels, colors, linewights, etc... (and can convert everything to dgns), but now I need to figure out how to get similar plotted results from both sets of drawings (the dwg and the dgn..)
I am using C3D 2012 and i know how to create a table showing volumes for different elevation ranges with different colours, but how to show the total cut or fill for the volume surface in the same table so that you dont have to manually add up all of the cuts or fills? or have to display only two ranges?
View 1 Replies View RelatedI am trying to create a line table. Here are the steps I am following :
First I label the lines I have drawn using a line label type for example Bearing over Distance, then I am going to the Annotate tab, Add Tables, Add Line and Curve and once I get to that dialog box I select my table style that I have already created and the label style I chose to label the line and click on the "apply" box and then "ok" and I see the labels such as L1, L2, etc. and all looks good, except now when I go to use that label style Bearing over distance to label another line, it labels the line with the tags and not the bearing and distance, its like the style is now defaulted to labeling tags and not bearing and distance anymore.
Is it bad to make a structure table from a DS? I find I get missing data when I do.
View 2 Replies View RelatedI had a table in a drawing on layer "Text" and I changed the layer of the table to "Text - Frozen" Then I decided I wanted the table back on layer "Text" and something strange happened. The text in the table appears to be on the layer "Text" but the lines which make up the table are still on layer "Text - Frozen". So when I freeze "Text - Frozen" I get only the content of the table with no lines. When I select the table, it is indicated that it is on layer "Text".
View 1 Replies View Related