Ole Excel Autocad
Gaetan Boren
Hello, I pasted an excel spreadsheet into a drawing file, and can no longer select it. I am trying to delete it because I have gotten better with the report table generator and would like to get away from having these excel files in my drawings. The excel file no longer exists, I'm assuming this is what is causing the problem. The drawing was created in AutoCADE 2016, and I am currently using 2017. I have three drawing files that are doing the same thing, and have attached one file for reference. Could someone please explain to me how to get rid of these excel spreadsheets? I have tried turning the frames on and off, and regening the drawing.
I would like to hear the explanation to. I do not see what the problem is but for down and dirty I selected the entire drawing with a crossing window and pasted it into a new drawing created with the acad.dwt template and the spread sheet did not come with it, just the frame and electrical panel.
After more research on this issue. I have found that people are having this issue with the defpoints layer. Apparently if layer 0 is off, some items on defpoints cannont be selected. After reading that I looked into my layers in the drawing and noticed that the spreadsheet is on my psyms layer. I played with turning all the layers on and off freezing and unfreezing. That did nothing. I then proceded to delet everything from the drawing. including all layers except layer 0. The spreadsheet did not delet. I ran an audit and was told that it found and fixed 1 error. It also created a new layer "$AUDIT-BAD-LAYER." I tried deleting that layer and the spreadsheet still remains on the drawing. I do not know why I cant get rid of it. Thanks for looking into this also TRLitsey!
I was having the same problem. Lynn Allen tells you how in this article. Run OLEFRAME. Mine was turned off (0) and I just had AutoCAD 2017 installed last week on my computer at work. Changed it to 1. Problem solved. This was a simple fix, surprised no one else posted this solution.
I simply want to paste a series of cells from excel into an existing autocad table. About 8 rows, 1 column thick. I want the values to acquire the destination formatting too if possible. I do not want to create an OLE object or anything fancy. I have seen instructions to use "Paste Special" on forums, but I do not have this choice when I right-click. I'm sure this is possible.
When I go into an AutoCad table cell, I do have "Paste Special" > "Paste without Character Formatting" as the only option. This pastes all data for multiple rows into one cell. I want to enter data into multiple rows at once:
I think we are not on the same page. If I am not wrong, you want to extract some values from Excel tables directly into existing Autocad tables. I have not tried that because I don't like using the Table function in AutoCad since it is very slow and very limited in function. I do all my tables and calculations/programming in Excel and then I would just paste them onto Autocad. You can highlight/copy the range in Excel and then right click in Autocad and it will allow you to paste the excel file as a one autocad entity. The problem with this is that if you update the Excel file, the one pasted on Autocad will not be updated. However, if, after you higlight/copy a range in Excel, go to your Autocad drawing but instead of right clicking, click on the Edit pulldown menu then click on paste special then click on paste link. It does create an OLE and each time you update and save the Excel file it will automatically be reflected on the Autocad.
when i paste the table from excel to auto-cad , the color of the text is black and the text style inside the table is standard , how can i change it to any other text style without edit cell by cell ?
I SELECTED ALL THE CELLS I WANT THEN I COPED IT IN TO AUTO-CAD AS WRITTEN . THE TEXT COLOR IS BLACK AS IN THE EXCEL SHEET , TO SOLVE IT I CHANGED THE TEXT COLOR IN EXCEL THE I COPED IT TO AUTO-CAD , IS THAT RIGHT ?
The text color comes in as black 0,0,0 and does not correlate with the standard white (7) in my layer. To change the color, I have to change it via Text Edit by changing the text in each individual cell to By Layer (white). This is very time consuming... Is there a work around?
Actually I'd recommend first setting up a named range in your excel file and then create a new datalink. Select that (excel) file and the named range, you should see a rectangle in the preview window. Then expand advanced settings (circle with right pointing arrow inside) and check over those options. You can treat it like an X-Ref and reload the information from the excel file into your drawing (from context menu when table is selected) or you can push the changes back into the excel file (again from the context menu).
this creates an OLE object with plenty of other problems. Have you tried to increase the size of a table like this? (Autodesk may have improved it over the years but it used to be a nightmare). Datalink is MUCH better and allows editing the native file and updating the drawing if necessary.
Hi, I'm trying to get a field to display a string of text from an excel file. I currently have a data link to the excel file, with a table displaying a range of cells from a sheet in the file. I have successfully used a field to display a number from a cell in that table, but whenever I try it with text I get ####.
The gist of what I'm trying to do is to get a text box on one of my CAD sheets to display something like "the system at ______ is installed..." with ______ being a variable string of text from my excel file.
I looked into custom properties a bit, and it looks like text fields work fine there, but I'm still trying to figure out how to link them to my excel file (aka make Excel populate/update the custom properties automatically). Is this something that can be done via DATALINK? Or will it require some custom scripts? I have experience getting VBA scripts to manipulate other CAD programs I've used in the past, but haven't tried it with AutoCAD yet (and haven't had a whole lot of time to pore over it recently).
If you are really trying to tie this to Excel then perhaps you should use Attributes with ATTIN and ATTOUT. Here is an article that details their use. The drawback is that it tracks the attributes by their handle so it is drawing specific.
After entering "Data Link Name" and hitting OK, AutoCAD prompts me w/ "Table - Excel not found / The data link cannot be crated because Excel cannot be found / Check to make sure that Microsoft Excel is installed properly on this computer.". I use this feature frequently and have yet to receive this error. This is the first time I've tried to link an Excel table, since the 2021 upgrade (about 3wks ago to 2021.1). I've confirmed Microsoft 365 is up to date.
@pendean we are having the same issues here as well. Unfortunately the above link does not resolve our issues. We have two computers, both with 32 bit Office and 64 bit Autocad. One computer can link excel the other can't. We used the link to delete old registry files and we are still having the same issue. And just to save some back and forth, we also uninstalled/reinstalled autocad as well as MS Office. We still cannot get one computer to link excel.
We are having the same issue that you described. We also reflashed the computer back to OEM and installed office and Autocad2020 and we still have the same issue. Please advise if you find a working solution.
It's a very serious issue, I have the same, and Autodesk's troubleshooting boils down to reinstalling Office and / or Autocad. Too bad there is no reasonable fix. I will look up other forums, maybe AUGI, for a solution.
We were able to resolve this issue by creating a named range in excel and choosing "Link to named range:" when creating the data link. I assume AutoCAD has issues with sizing the document when using "Link entire sheet".
Same issue here, some of our systems work fine and can link excel files. My system with the same software load fails as described here. I did finally get this working under ACAD2022, but now that I have upgraded to 2023 it is broken again and the previous fix does not work.
This was the key I had to change on my system to get Acad to play nice with Excel. The standard O365 installation points at a different Office16 folder for the MSO.DLL file. It would be wicked cool if the folks at Autodesk would make Acad a little less picky about the location of MSO.DLL. So far it looks like Excel is working with the different path for the MSO.DLL file.
This was the fix for me, I have 30 users and 1 user had this issue. I checked my reg key to and it matched this... Checked the user having the issue and that computer had a different location. I changed the .DLL location to this and boom.. No more issue. Regedit didn't even make me reboot.
In a previous project, we had the same issue but we found this tool called Microsoft Office Importer. We were able to link our Excel file with no issue. The process proceeded smoothly without encountering any transfer or formatting issues, even after making changes to our Excel file the imported spreadsheet maintained its original appearance flawlessly, reflecting the format. hope this information answers your question.
Here is a good page I found on how to edit and work with the Windows Registry. Basically, in your Windows search bar, type Run. In that screen type Regedit. The registry will open and then find the registry key where the user above posted. For registry help, see this page.
We have experienced load times upwards of 5 minutes, sometimes, when loading a file with several OLE links to excel spreadsheets. We've been using Excel (Office 365 in use) for schedules, and if we link 5 or 6 different xlsx tabs (maybe 20 columns by 40 rows, not esp large), the time to OPEN a 500KB (KB not MB) drawing in Autocad MEP 2020 can be over 5 minutes. If I get impatient and start clicking to see if I am missing something, I am likely to get an AutoCAD fatal error. It seems to hang on Regenerating Model (the last step). OTOH, if i close the file and then reopen right away, the load may be as fast as 10 seconds.
c80f0f1006