AutoCad :: How To Completely Delete Table Data Link
Jun 2, 2010
Using 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?
View 9 Replies
ADVERTISEMENT
Dec 26, 2011
I'm messing around with tables and data links, practicing. I copied a range of cells in Excel, and did paste special to create a linked table.
Now I can delete the table object, but I cannot delete the link, cannot detach it.
When in Data Manager if I right click on the data link and click delete I get the error message "The data link is being used and cannot be deleted".
I have tried detaching, and the detach does not seem to take.
Now also, the table will not update from the source xls.
Win XP, AcadLT 2011, Office 2010. Using compatible setting for saving spreadsheet, for Office 2007 (not xlsx).
If I create a linked table by starting with the Table icon, choose "from a data link", choose the excel spreadsheet, etc., then I am able to later update the table from the spreadsheet, detach, delete the link, etc. But I can only delete the link if the table is not selected when I open the Data Link Manager.
But the one that was created following the directions from the Autocad video, with the copy, paste special, that link will not detach nor delete.
View 5 Replies
View Related
Dec 10, 2012
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]
View 1 Replies
View Related
Nov 23, 2011
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 Related
Mar 16, 2012
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??
View 8 Replies
View Related
Apr 26, 2011
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 Related
May 5, 2011
I 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.
View 1 Replies
View Related
May 10, 2012
So 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?
View 1 Replies
View Related
Mar 19, 2012
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?
View 1 Replies
View Related
Feb 18, 2013
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 Replies
View Related
Apr 24, 2013
I loaded a linetype (.lin file) in ACAD 2010 and it came out wrong. I would like to permanently remove it from ACAD(where it cant be seen when you go to load another type of line), how do you do that?
View 7 Replies
View Related
Mar 28, 2013
I have a drawing with Objects that have both Object Data and Linked data in an Access database. I need to get information from the linked table to a new linked table for each object.
I have thought that if I get the necessary information from the Linked table record to the object data for each object, I could then convert the Object data to a new link and am looking for a way to copy the data from a field in the Linked Table to the object data. There is at least one field common to both the OD and Linked Table record.
Is there any automated way to transfer this data?
View 5 Replies
View Related
Jun 25, 2013
In my company, they have just upgraded the old version of Autocad LT 2004 to the new 2013 and we have created menu to make our job easy. I have try to transfer the menu file .mnc to 2013 but it's not working or I don't do it the right way.
View 4 Replies
View Related
Oct 24, 2013
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
View 2 Replies
View Related
Jan 20, 2012
Is it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
View 2 Replies
View Related
Feb 13, 2012
We 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?
View 3 Replies
View Related
Aug 19, 2010
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 Related
Feb 26, 2013
Is 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.
View 2 Replies
View Related
Mar 13, 2012
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?
View 3 Replies
View Related
Jul 29, 2011
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?
View 9 Replies
View Related
Apr 6, 2011
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.
View 4 Replies
View Related
Jan 24, 2013
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.
View 6 Replies
View Related
Jun 7, 2012
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.
View 2 Replies
View Related
Nov 1, 2012
When trying to insert a table linked to an Excel 2010 file, it works up until row 28, however, as soon as I add a 29th row to the table it no longer inserts the table. When I try and insert it, I press ok and nothing happens. I tried inserting it as a smaller table and changing the data link to a bigger range after it was inserted, it just didn't update to a larger range.
Is there a way of getting this to work without having to insert it as two different tables?
View 2 Replies
View Related
Aug 19, 2009
how to remove this link from my template. I don't see the table in MS or PS. When I right-click on the link I get the message: "The data link is being used and cannot be deleted."
View 2 Replies
View Related
May 6, 2013
I'm simply trying to delete the revision table if it exists on a drawing. I did find where you can't do anything with Rev Tags with the API, but what about the Actual Revision Table?
Trying to get this to work;
If iProperties.Value("Project", "Revision Number")>0Dim oRevTable as RevisionTableoRevTable = ActiveSheet.Sheet.RevisionTable.Item(1) oRevTable = nullRevisionTable
View 2 Replies
View Related
Jan 7, 2013
We recently tried to convert a RAW data file to FBK and the program aborted after running several setups. I have viewed the raw data on the data collector, but there appears to be no error. What other methods of conversion could I use to convert the RAW data file to a TXT file? I was hoping that our local AutoCad/Topcon dealer would be able to have a work-around, but they seemed stumped too. We have never encountered a problem usitlizing the Survey data Collection Link with any of our traverses prior to this time.
View 3 Replies
View Related
Apr 11, 2012
I'm using the ribbon in 2012. I've got a drawing index sheet I want to update, and what I need to do to get to the Edit Data Link command is switch to the Classic interface and select the table in order to display the Table toolbar with Edit Data Link button.
I cannot find this anywhere on the ribbon, and the same button icon as Edit Data Link on the Table toolbar runs Data Link Manager from the Annotate tab, Tables panel on the ribbon, which is not what I want.
Where is this on the ribbon? And how come identical tool buttons run different commands in different workspaces?
View 5 Replies
View Related
Sep 9, 2010
When I try to reference an object in the Data Shortcuts menu, when I right-click the a profile in Prospector under Data Shortcuts, the option to "Create Reference..." is grayed out, and I am unable to reference that profile into the drawing I am working on. It works fine on other profiles that are being referenced from the same drawing.
I have tried:
1. Re-creating the alignment and profile data shortcut in the drawing being referenced
2. Creating a reference in my drawing to the alignment, which actually works. However, it still does not allow me to "create reference" for the profile.
3. Refreshing the data shortcuts.
4. Synchronizing the alignment referenced in the drawing.
Nothing seems to work. My only other option is to move the C3D profiles from the referenced drawing to the drawing I am working in. Is there a way to do this?
View 8 Replies
View Related
Nov 19, 2013
I need to create a small table to ID the User, Computer name, Door Key, etc for a floor plan drawing of our office. I'd like to get this done in Excel and link it all so the bldg manager can make changes to the drawing without me. I have created the excel file and created a "name set" in excel for each room. In Autocad 2013 I have inserted a table from a data link and pointed that link to the named range of the room (the named range in excel is an 8 cel block with al the info I need repeated and uniquely named for each room.
This works great...so my next step is to create a block out of the table and make the DATA LINK a variable attribute...that's where I'm stuck. i cannot figure out how to do this. I would love to be able to INSERT BLOCK and have one attribute question...ROOM NUMBER?. That should look to the excel NAMED SET the corresponds and populate the table.
View 1 Replies
View Related
Jan 5, 2011
I have been tasked with finding a way to link data from Oracle and SQL databases with CAD files of rooms in certain buildings. My goal is to be able to select an arbitrary room within a building and be able to access certain information. I don't actually have access to the databases yet, but I would like to know how to do this when I do. My data consists of "human" data such as: name, email, position, sex, etc; as wells as "physical" data such as: square footage of the room, who uses it, computer serial numbers, or what department is in charge of it. Using this data we will cross reference the tables to determine what our needs are.
My AutoCAD skills are good but I've never come across anything like this in the class room. Most of my knowledge is Civil based and more focused on design.
View 9 Replies
View Related
