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 RepliesI 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.
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.
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
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.
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?
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 RelatedI 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 Relatedwe 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 RelatedAs 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 RelatedHere are my current steps for getting prints to shop floor;
1. download a list of drawings required from as/400 into Excel.
2. saveas .csv file
3. print mfg labels using label program reading .csv file
4. using labels, open .dwg from ACAD one at a time and print ea
5. apply labels to prints
6. give to mfg
I want to do this;
1. download a list of drawings required from as/400 into Excel
2. run macro to concanteate file location, name and .dwg to new column
3. run macro to print each drawing either from Excel or Acad - not sure which is better;
- Each drawing will have all label data incorporated in the drawing
- currently nothing is in the drawing for label data, I'll need to create it.
- should I insert a block that updates with the excel row data
4. give to mfg
My first goal is to be able to batch print with the same list that I use to create the labels, then I'll focus on getting the label data incorporated on the drawing.
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 RelatedIf it is possible to plot points (or a PLine, or a mesh) in AutoCAD from a table of values in EXCEL (columns of x,y,z coordinates).
View 8 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.
how do I plot L & X-section of Road from excel data that has chainage and RL at the centre,left and right of the chainage point?
View 1 Replies View Relatedi haved data with in excel with formatting text, i want in autocad automaticly became plot, with format same as with the picture above ...
from excel where is the data will input manually 62038220.jpg
and then in autocad will automatic became ... 31629060.jpg
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.
I recently switched to a new machine and manually copied and pasted my custom settings over and set paths to the new location. Everything seems to work fine except when I click on "Plot Stamp Settings".I receive an error that says "Data Link Files" and sometimes it says "LISP".
View 1 Replies View RelatedI have a table which is linked to a datalink from Excel. The table and contents (text) show up in paperspace; however, only the table frame shows up within the plot preview, or when I try to plot it. The text does not show up.
View 4 Replies View RelatedWhen 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.
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 RelatedAbout 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?
I'm using autocad 2000 and I have a problem printing & plotting. The print, plot preview only shows a section of the drawing. What settings do I need to change for the entire drawing to print for the paper size I need.
View 3 Replies View RelatedI have one drawing per file at model tab. When I need to plot a multiple page file, I use:
Print > Batch Plot.
The problem is that I have to set plot configurations ( plot style table, plot area, paper size, etc) in each file before use Batch Plot.
Now I received 722 files with a wrong Plot Style Table. For this time I change the associated *.ctb file at Plot Style folder, but I will need to associate the right *.ctb to each drawing. It's also common to have to change other properties.
When the attached shape file (change soilmu_a_a.txt to .shp) is imported using MAPIMPORT the data aligns with other imported georeferenced raster imagery (said imagery was imported using the MAPIINSERT command). If the same shape file is imported using the data connect tool it shows up in a much different location (see word document).
The drawing coordinate system code is "UTM83-18F" and the data was downloaded from the Web Soil Survey's data download with the identical coordinate system (see attached readme.txt).
I prefer to use the data connect option when importing this type of shape file because I can label them all using a theme and use stylize the data for visualization/presentation.
As an aside, I have found that data connect does not automatically transform data coordinate systems to match your drawing coordinate system as advertised. I've used the edit coordinate system to no avail; however, again when the file is imported using MAPIMPORT and saved as a drawing (with native data coordinate system) and then that drawing is queried from a drawing in a different coordinate system it seems to transform the coordinate system just fine. Is this a problem with data connect?
i have line in the drawing that exists on layer A-Wall it has different lineweight 0.05 from true wall. Now usually my routine : i select this line and then select similar to convert it to layer glazing.
i need lisp that by one command convert the objects on layer A-wall with layer 0.05 only to glazing.
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?
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 RelatedWe 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?
Windows 7; Photoshop 13 (CS6).I am typing some text in a new layer; no problem so far. I need to insert some special characters that are not on the keyboard, e.g.TōkaiThat also was not a problem; I copied the character from the Windows Character Map.
Now I want to copy/paste more special characters from the Character Map, e.g.
☏ (U+260F) or
✉ (U+2709)
Now all of a sudden this does not work; the pasted characters appear in Photoshop as a boxed X.The font I have been using was Arial, but when I pasted these Unicode characters, the font automatically changed to Myriad Pro. Changing the font back to Arial does not alter the boxed X.
I took these Unicode characters from the Character Map using font Arial Unicode MS. That font does not appear in Photoshop.Questions:are there any Unicode fonts available in Photoshop?is there any other way to paste such characters into Photoshop?
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.