Community
AutoCAD Forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Unable to link Excel Table link

19 REPLIES 19
SOLVED
Reply
Message 1 of 20
tbuccieriTGYM4
11021 Views, 19 Replies

Unable to link Excel Table link

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.

19 REPLIES 19
Message 2 of 20
pendean
in reply to: tbuccieriTGYM4
Message 3 of 20
tbuccieriTGYM4
in reply to: pendean

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.

Message 4 of 20
ewegener
in reply to: tbuccieriTGYM4

@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.

Message 5 of 20
rwdentonZUWW9
in reply to: ewegener

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.

Message 6 of 20

Hi,

We upgrade to Autocad Electrical 2022 and we work with Microsoft 365 64bit updated .

 

We have the same problem, I have also tried to  Removing Outdated References to Office from the System Registry

and we still have the same issue.

 

Carlos

 

 

Message 7 of 20
atanasoiu
in reply to: tbuccieriTGYM4

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.

Message 8 of 20

Yes - this is a serious issue, and that article does not fix it. 

 

Message 9 of 20

This is an AutoDESK problem with their software - nothing wrong with our installations. They need to fix this instead of giving bogus solutions.

Message 10 of 20
rmorrell
in reply to: tbuccieriTGYM4

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".

Message 11 of 20
candersonQDLXQ
in reply to: rmorrell

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.

Message 12 of 20
mbrenneis
in reply to: tbuccieriTGYM4

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?

Message 13 of 20
pendean
in reply to: mbrenneis


@mbrenneis wrote:

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?

Message 14 of 20
mbrenneis
in reply to: pendean

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:  
    Key:
    HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win64
    New value - should be the directory path to where the most current version of MSO.DLL file resides on the machine. For example:
    C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\MSO.DLL
Message 15 of 20
dayne.moreton
in reply to: mbrenneis

Thanks @mbrenneis! I have referenced your solution twice to make my excel link frustrations subside. I appreciate your help!
Message 16 of 20
l.miller5DDJX
in reply to: mbrenneis

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. 

Message 17 of 20
blakemep
in reply to: mbrenneis

How do I do this?  I'm not technically inclined at all 😞

Message 18 of 20

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.

 

Message 19 of 20
rfischer6TTS8
in reply to: blakemep

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.

 

https://www.bleepingcomputer.com/tutorials/how-to-use-the-windows-registry-editor/

Message 20 of 20

I changed the path "

C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\MSO.DLL

" at all of these locations to fix the issue. Someone had upgraded office from 32bit to 64bit in that machine.

 

Computer\HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win64
Computer\HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.8\0\Win32
Computer\HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.6\0\Win64
Computer\HKEY_CLASSES_ROOT\TypeLib\{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}\2.7\0\win32

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

State of Sustainability Webinar


AutoCAD Inside the Factory