AutoCAD 2010 :: Paste Special / Link - Excel On DWG Shows Wrong Data On XP Workstations
Sep 18, 2012
I have an issue between XP 32 bit ACAD 2011 workstations and Windows 7 64 bit ACAD 2011 workstations...
1 - A Windows 7 user does a Paste Special>Paste Link>Microsoft Excel to insertembed a portion of an Excel worksheet into the DWG.
2 - various win7 and XP users make changes to the Excel worksheet directly in Excel
3 - Win7 users open the DWG to see the correct and updated Excel data in the DWG
4 - XP users open the same DWG to see OLD data from a previous save and not the correct updated data on the linked worksheet
5 - XP users directly open the Excel file in Excel and are able to view the correct updated data BUT NOT IN THE DWG
6 - XP users see old incorrect excel worksheet data in the DWG. Win7 users see the correct data in the DWG.
View 5 Replies
ADVERTISEMENT
Apr 16, 2013
The company I currently work for imports excel data via the paste special / link method. It works fine, however when i open obviously or plot through sheet set manager specifically and someone is in the excel file i get the read only message and have to click the box in excel to either read only or notify. How can i run plots and not have to check that box?
View 2 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
Feb 1, 2013
I'm inserting a data link from excel into my CAD drawing and every time I try to select the table it brings in, the corner "grips" the green plus signs, are so huge they are bigger than my sheet and I can't see anything in the table. Any way to shrink them to a rational size?
View 2 Replies
View Related
Sep 6, 2012
When I try to paste in any collection of cells from excel using "paste special" C3D crashes. I'm using 2010. It crashes trying to paste into any drawing, and any group of cells.
My error is:
Unhandled Access Violation Reading 0x209519f8 exception at 478f56h
View 3 Replies
View Related
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
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
Dec 23, 2013
I have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
View 6 Replies
View Related
Jul 24, 2013
I want to link Microsoft Excel data with AutoCAD drawing (like dimension or values). When I made some changes in Excel data, value in AutoCAD drawing can be changes automatically.
View 1 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
Mar 24, 2011
As title says, I create a new Excel Data Link using "Data Link Manager" but it takes forever! If so, how can I get rid of waiting long time when creating/editing a Data Link?
View 0 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 14, 2013
I'm laying out a report with many graphs of similar styling, the client is to provide an Excel doc with the figures and I need to redraw them as graphs.Is it possible to design the graph style in Illustrator, import the data from the spreadsheet to the graph and then place the graph(s) into InDesign. Essentially, this is what I'd like to achieve:
1) Style/design a graph in Illustrator
2) Import spreadsheet data into Illustrator graph (a step I'm also haveing problem with - is it possible to import an entire Excel doc or do you have to copy and paste each cell individually)
3) Import Illustrator graph into Indesign
4) If original data in Excel is changed/updated and the document is saved, data will update in Illstrator and therefore in InDesign.
View 4 Replies
View Related
Feb 14, 2012
I'm trying to link excel to autocad for a time now.
and until now it didn't work for me.
Everytime it says "1 data link(s) do not allow their data to be written out."
thats when i try to write it to the excel file.
View 5 Replies
View Related
Oct 10, 2013
We are a MEP firm, using AutoCAD 2011 and Excel 2007, and our project is a building with 1000+ rooms. Each room has specified supply and return airflows that need to show up in text in each of the rooms. All the airflow values are calculated in a spreadsheet.
My thought is to use fields in the text that shows up in each room, then link each field to a specific cell in Excel, because these values will be evolving over the next year.
View 2 Replies
View Related
Oct 1, 2013
If I place a link to a dwg as a hyperlink in an Excel file, AutoCAD freezes. It opens the drawing, then AutoCAD is completely locked. I have to close it through task manager.
This has been tested wih multiple drawings and excel file and it happens in all of them. I'm using Excel 2010 and AutoCAD 2010.
Win7 x64 - 16gb ram
i7 3610qm
FirePro M4000
Inventor 2013
ETO 6.1
View 4 Replies
View Related
Jul 19, 2012
way I can link my AutoCAD title block attributes to excel and make changes in either excel or AutoCAD and then be able to run an update? The attributes would be “REV” “DWG_NO” “TITLE” “LOCATION” “DRAWING_SIZE” and “FILE NAME”.
View 4 Replies
View Related
Jan 27, 2012
I would like to link a series of text lines in an autocad drawing to there corresponding fields in an excel sheet, I can not use tables in autocad because of the way other software uses the text in autocad. I have attached files of the text layout in acad and of the sheet in excel. One thing that keeps me from using tables in acad is that every line of text is on a different layer, with tables you can't control the layer of table its always on the current layer.
View 6 Replies
View Related
Apr 5, 2013
This has happened on all versions of AutoCAD in our office.
I paste schedules from Excel into AutoCAD. I print out the sheets and ghost lines appear on the PDF and hard copy that were not intentionally place in the excel file. What is happening and what can be done about it.
I also paste a tif file on a sheet change the setting to imageframe <0> and a residual line willl appear in pdf and hard copy that seems to be the border of the tif image.
View 4 Replies
View Related
Sep 21, 2011
Seems like i export the data of thickness, diameter, lenght and mass to excel via dataextraction, but if i change something in the drawing, its not updated in the excel file..
I also wanted to export the data to an already existing part list template, but this seems impossible...
View 2 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
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
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
Sep 7, 2012
Is there a way to turn off the Data Link Updates? I want it to be a maual process. Right now it tries to update the data links when I print. It asks if I want to skip but I have to do that everytime I print. Can I turn that off. If it updates it destroys the formatting of the table.
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
Feb 20, 2013
I want to drawn LINE by excel data to autocad 2010, I have excel file x,y and z coordiates.
I want to draw line to import excel data coordiates to autocad ?
View 4 Replies
View Related
Sep 9, 2011
I recently decided to see how the AutoCAD tables work. I was very happy to learn you could link your Excel spreadsheets with CAD. But now I have a problem.
After inserting the table it refuses to use the table style I have set up. The fonts do not want to change at all. I can change the colour of the text, but not the font.
PS: Using AutoCAD 2011
View 7 Replies
View Related
Dec 13, 2011
We are running AutoCAD Architecture 2012 on a Windows 7......64bit workstation and AutoCAD will suddenly crash for no apparent reason. When I look in the event log it makes a reference to the AcDB18.dll
View 6 Replies
View Related
Oct 30, 2008
When I link in an excel document to my model all parameters in that excel gets the unit (mm).
How can I change this? For instance I want some of the parameters to be an angle.
View 8 Replies
View Related
Aug 30, 2013
As everybody know copy/paste excel file into an inventor drawing is sometimes difficult. As you can see in the printscreen a special character is not converted. I supposed it's because this special character is not in the AIGDT or is in the extended character set wich is not considered in Inventor?
View 2 Replies
View Related
Jul 11, 2013
About 50% of the time, when I take a screenshot of part of a pdf (using acrobat's screenshot tool) when I go to paste it into C3d, I choose paste special, and then image object, and the screen goes pale and I get the C3d has encountered an error and needs to close message.
I have installed the latest hotfix which was recommended after a save to dxf crash this morning but just had it crash out again with a paste special.
When this crash happens, it never asks me to send in a report.
I am using C3d 2013. the 64bit version, on Win7 pro 64 bit SP1,Intel (R) Xeon (R) CPU E3-1240 V2 @ 3.40ghz and 3.40ghz. 16gb RAM, and AMD FirePro V5900 2gb graphics card.
The computer should be able to cope, but I find that it lags if I just insert whole pdfs and I usually only need a bit of the image.
Is there anything I can do apart from always convert the pdf into a jpg first?
View 5 Replies
View Related
