Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show only
|
Search instead for
Did you mean:
This page has been translated for your convenience with an automatic translation service. This is not an official translation and may contain errors and inaccurate translations. Autodesk does not warrant, either expressly or implied, the accuracy, reliability or completeness of the information translated by the machine translation service and will not be liable for damages or losses caused by the trust placed in the translation service.Translate
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.
Thanks, @pendean. 365 is 32bit and may be the cause. however, I've never experienced this, before. I put a ticket into IT to look at changing 365 to 64bit.
@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".
Nope. If AutoCAD is not recognizing Excel you can't even get to the point of picking a named range. I've always used a named range, that has nothing to do with it.
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.
The solution link up there is from 2016 and out dated. C'mon AutoDesk how about we find this and fix it?
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.
What fixed it in 2022 for you? Not seeing much of any issues here so I'm not sure I can follow along, can you share sample files from 2022 that do not work in 2023?
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.
Snip from the 2023 help note:
Fix the MSO.DLL scenario by editing the pertinent registry key to point to the newest version of MSO.DLL on the machine, or proceed to the below solution regarding "Corrupt Installation", if the file is missing altogether:
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.
I agree Autodesk must fix how it looks for this file.
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.
The answer above involves editing the Windows Registry to point to the proper Microsoft Excel Location.
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.
