# Excel Data.ImportExcel operation Failed **URL:** \ **Category:** Revit\ **Tags:** excel\ **Created:** [March 26, 2021, 6:17pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197 "2021-03-26T18:17:23Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Ben\_Osborne](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ben_osborne/32/17366_2.png) [@Ben\_Osborne](https://forum.dynamobim.com/u/Ben_Osborne)\ **Post date:** [March 26, 2021, 6:17pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/1 "2021-03-26T18:17:23Z")
Anyone having Excel import trouble today? Computer ran windows updates 2 days ago and suddenly I cant import Excel. note that i also installed Autocad and Navisworks 2022 yesterday as well. This is Revit 2020 - Dynamo 2.3 ![ExcelError](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/d/0/d0570aac83460cb3b0fbab809d57c50e97a8ce08.png) ---
**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\ **Post date:** [March 27, 2021, 6:15am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/2 "2021-03-27T06:15:37Z")
Hi @Ben_Osborne Have you update Revit 2020 to Revit 2020.2.3? [https://help.autodesk.com/view/RVT/2020/ENU/?guid=RevitReleaseNotes\_2020updates\_2020\_2\_3\_html](https://help.autodesk.com/view/RVT/2020/ENU/?guid=RevitReleaseNotes_2020updates_2020_2_3_html) Similar issue have been discussed here: > [@Data.ImportExcel operation failed. Excel is not installed](https://forum.dynamobim.com/t/data-importexcel-operation-failed-excel-is-not-installed/57394/9): > > To @Alban_de_Chasteigner’s point, this is almost certainly a failure that stems from a bad installation, likely causing an issue in the registry related to interop. A repair should help, but you may need IT to clean the installation entirely and try again. ---
**Author:** ![Ben\_Osborne](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ben_osborne/32/17366_2.png) [@Ben\_Osborne](https://forum.dynamobim.com/u/Ben_Osborne)\ **Post date:** [March 27, 2021, 1:32pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/3 "2021-03-27T13:32:24Z")
Been on 2020.2.3 for a while. I finally was able to fix the issue last night by doing a repair on the Office 365 install. Seems that either the Windows Update carried some Office updates or the .Net upgrade that came with install of 2022 Autocad/Navisworks messed things up just a little bit. ---
**Author:** ![mzjensen](https://avatars.discourse-cdn.com/v4/letter/m/b77776/32.png) [@mzjensen](https://forum.dynamobim.com/u/mzjensen)\ **Post date:** [April 26, 2021, 8:42pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/4 "2021-04-26T20:42:41Z")
I had the exact same issue and it was only fixed by reinstalling Office 365. Doing a repair did not work. ---
**Author:** ![paulbracchitta1](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/paulbracchitta1/32/110833_2.png) [@paulbracchitta1](https://forum.dynamobim.com/u/paulbracchitta1)\ **Post date:** [June 9, 2021, 10:20pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/5 "2021-06-09T22:20:38Z")
I had this issue just start today for me as well after working no problem yesterday. I also just installed Navisworks 2022 today. Also was only fixed by reinstalling Office 365. Thanks for posting. This is hugely helpful to hear this–so, something’s up with Navisworks 2022 installation it seems? ---
**Author:** ![mzjensen](https://avatars.discourse-cdn.com/v4/letter/m/b77776/32.png) [@mzjensen](https://forum.dynamobim.com/u/mzjensen)\ **Post date:** [June 10, 2021, 2:14pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/6 "2021-06-10T14:14:23Z")
FYI @Michael_Kirschner2 @solamour It seems like this has been happening pretty consistently to several users. ---
**Author:** ![RobFern](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@RobFern](https://forum.dynamobim.com/u/RobFern)\ **Post date:** [July 14, 2021, 11:03pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/7 "2021-07-14T23:03:45Z")
Yep we are facing the same issue. We are having to reinstall Office 365 every time there’s a windows update. ---
**Author:** ![pawel.kS3DHM](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/pawel.ks3dhm/32/120171_2.png) [@pawel.kS3DHM](https://forum.dynamobim.com/u/pawel.kS3DHM)\ **Post date:** [July 15, 2021, 9:27pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/8 "2021-07-15T21:27:59Z")
I will write for others from the future. I had the same error but in my case i needed to uninstall office 2007 and invest in office 365 ---
**Author:** ![Michael\_Kirschner2](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/michael_kirschner2/32/75576_2.png) [@Michael\_Kirschner2](https://forum.dynamobim.com/u/Michael_Kirschner2)\ **Post date:** [July 16, 2021, 12:15am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/9 "2021-07-16T00:15:40Z")
@RobFern please this note from MS: [Starting third-party add-in causes "Access Denied" error - Office | Microsoft Docs](https://docs.microsoft.com/en-us/office/troubleshoot/installation/access-denied-error-when-starting-third-party-apps?branch=pr-en-us-1383). ---
**Author:** ![WrightEngineering](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/wrightengineering/32/115676_2.png) [@WrightEngineering](https://forum.dynamobim.com/u/WrightEngineering)\ **Post date:** [July 16, 2021, 6:24am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/10 "2021-07-16T06:24:53Z")
Can confirm. Had same issue after installing navisworks 2022 and had to use external package to read excel. ---
**Author:** ![\_Vijay](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/_vijay/32/91307_2.png) [@\_Vijay](https://forum.dynamobim.com/u/_Vijay)\ **Post date:** [July 16, 2021, 6:34am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/11 "2021-07-16T06:34:48Z")
> [@Excel import Error in Revit 2020](https://forum.dynamobim.com/t/excel-import-error-in-revit-2020/65600/7): > > @_Vijay Similar issue was discussed here: ---
**Author:** ![Teja5zz](https://avatars.discourse-cdn.com/v4/letter/t/e9a140/32.png) [@Teja5zz](https://forum.dynamobim.com/u/Teja5zz)\ **Post date:** [July 16, 2021, 7:23am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/12 "2021-07-16T07:23:54Z")
This is very annoying , this happens due to the conflict with 32bit or 64 bit version of excel installed on your system. ---
**Author:** ![RobFern](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@RobFern](https://forum.dynamobim.com/u/RobFern)\ **Post date:** [July 16, 2021, 10:10am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/13 "2021-07-16T10:10:51Z")
Thanks for this! I just ran the online repair, fingers crossed it resolves the issue going forward. ---
**Author:** ![RobFern](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@RobFern](https://forum.dynamobim.com/u/RobFern)\ **Post date:** [July 16, 2021, 11:32am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/14 "2021-07-16T11:32:00Z")
I ran the online repair and it caused the issue to occur again, so I’ve had to reinstall office again. ---
**Author:** ![AnthonyZ](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/anthonyz/32/89527_2.png) [@AnthonyZ](https://forum.dynamobim.com/u/AnthonyZ)\ **Post date:** [July 20, 2021, 3:48am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/15 "2021-07-20T03:48:42Z")
I’d like to chime in as one more person that is experiencing this issue after installing some 22 products recently. Reinstalling office appears to have fixed the issue for the time being. ---
**Author:** ![Ben\_Osborne](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ben_osborne/32/17366_2.png) [@Ben\_Osborne](https://forum.dynamobim.com/u/Ben_Osborne)\ **Post date:** [July 20, 2021, 11:32am UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/16 "2021-07-20T11:32:42Z")
FWIW - I had to do the repair again after Windows Update last week. ---
**Author:** ![Paul\_Aubin](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/paul_aubin/32/9908_2.png) [@Paul\_Aubin](https://forum.dynamobim.com/u/Paul_Aubin)\ **Post date:** [August 5, 2021, 4:03pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/17 "2021-08-05T16:03:17Z")
I was having the same issue. Shockingly, the repair option for office fixed it. In my experience, it is not usually that easy. But I’ll take it! ---
**Author:** ![Teja5zz](https://avatars.discourse-cdn.com/v4/letter/t/e9a140/32.png) [@Teja5zz](https://forum.dynamobim.com/u/Teja5zz)\ **Post date:** [August 12, 2021, 2:23pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/18 "2021-08-12T14:23:35Z")
This issue was fixed with online repair on my personal laptop,But on my work laptop I have this issue, I couldn’t fix it. ---
**Author:** ![RobFern](https://avatars.discourse-cdn.com/v4/letter/r/bc79bd/32.png) [@RobFern](https://forum.dynamobim.com/u/RobFern)\ **Post date:** [September 15, 2021, 1:08pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/19 "2021-09-15T13:08:32Z")
Still happening to me after windows updates. Need to reinstall office 365 every time to resolve… ---
**Author:** ![bschneiderhan](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@bschneiderhan](https://forum.dynamobim.com/u/bschneiderhan)\ **Post date:** [December 23, 2021, 5:19pm UTC](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197/20 "2021-12-23T17:19:48Z")
Had the same issue happening for me in Revit 2020. Located the linked solution on Autodesk forum [Import Excel Solution](https://knowledge.autodesk.com/support/revit/troubleshooting/caas/sfdcarticles/sfdcarticles/Warning-Data-ImportExcel-operation-failed-Could-not-load-file-or-assembly-Microsoft-Office-Interop-Excel-when-running-the-Dynamo-script-in-Revit.html) [Next page](https://forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197.md?page=2)