# Data.ImportExcel operation failed **URL:** \ **Category:** Revit\ **Tags:** excel\ **Created:** [October 19, 2018, 1:31pm UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417 "2018-10-19T13:31:08Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Dora](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@Dora](https://forum.dynamobim.com/u/Dora)\ **Post date:** [August 5, 2021, 7:07am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/21 "2021-08-05T07:07:09Z")
Hi David, I had the same issue and I could resolve it by using normal xls file instead of xlsx. I hope it helps you too. ---
**Author:** ![fzbenouaziz](https://avatars.discourse-cdn.com/v4/letter/f/f04885/32.png) [@fzbenouaziz](https://forum.dynamobim.com/u/fzbenouaziz)\ **Post date:** [August 12, 2021, 8:24am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/23 "2021-08-12T08:24:47Z")
I had the same issue and it worked by repairing the Office ---
**Author:** ![m.fasher](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@m.fasher](https://forum.dynamobim.com/u/m.fasher)\ **Post date:** [January 18, 2022, 3:12am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/24 "2022-01-18T03:12:10Z")
Hi All, Did we ever find a concrete solution to this issue. I am now facing the same issue on my newer machines ☹ ---
**Author:** ![mho](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@mho](https://forum.dynamobim.com/u/mho)\ **Post date:** [January 27, 2022, 3:33pm UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/25 "2022-01-27T15:33:35Z")
This did help for me, thanks ---
**Author:** ![ugis](https://avatars.discourse-cdn.com/v4/letter/u/bc8723/32.png) [@ugis](https://forum.dynamobim.com/u/ugis)\ **Post date:** [January 31, 2022, 3:06pm UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/26 "2022-01-31T15:06:48Z")
I had the same error as @Michael_Coffey. What helped me was Repairing Excel. So far this issues has not reapeared. ---
**Author:** ![chacha](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chacha/32/137852_2.png) [@chacha](https://forum.dynamobim.com/u/chacha)\ **Post date:** [May 8, 2022, 7:43pm UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/27 "2022-05-08T19:43:45Z")
Thanks to everyone! “REPAIRING OFFICE” did the job for me. I was having the same issue , was working on it since last ten consecutive hours. I was seeing that same error faced by many people since 2017 or before and still the developer or unable to give the description of error in dynamo so that one should do thay needs to be done instead of wasting time just like MYSELF! ---
**Author:** ![Arun\_Chachad](https://avatars.discourse-cdn.com/v4/letter/a/b5e925/32.png) [@Arun\_Chachad](https://forum.dynamobim.com/u/Arun_Chachad)\ **Post date:** [May 25, 2022, 7:56am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/28 "2022-05-25T07:56:40Z")
Uninstalling and reinstalling 365 did the job for me. ---
**Author:** ![Extrawurst](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@Extrawurst](https://forum.dynamobim.com/u/Extrawurst)\ **Post date:** [July 13, 2022, 9:42am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/29 "2022-07-13T09:42:24Z")
Just got this error and just like the rest repairing Excel did the trick! (I could still write to CSV and to XML, just not Excel). ---
**Author:** ![jerom.van.wijnen](https://avatars.discourse-cdn.com/v4/letter/j/dbc845/32.png) [@jerom.van.wijnen](https://forum.dynamobim.com/u/jerom.van.wijnen)\ **Post date:** [September 23, 2022, 1:29pm UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/30 "2022-09-23T13:29:21Z")
This worked for me: > **[“Warning: Data.ImportExcel operation failed. Could not load file or assembly...](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)** > > When running the Dynamo script in Revit, which contains a node to import data from an Excel file the following message appears: “Warning: Data.ImportExcel operation failed. Could not load file or assembly 'Microsoft.Office.Interop.Excel,... ---
**Author:** ![CarlosIvan](https://avatars.discourse-cdn.com/v4/letter/c/cdc98d/32.png) [@CarlosIvan](https://forum.dynamobim.com/u/CarlosIvan)\ **Post date:** [September 27, 2022, 4:27am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/31 "2022-09-27T04:27:12Z")
Hi there, I’ve been researching around and I foud that my Microsoft Office Apps was in x32 version, and my operation system was in 64. When I reinstalled office with the x 64 version the script worked ok. So, in order to verify if you office is in x32 or 64, you can go to any office application then go to account and next go to About. ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/2/020ac8ccb618fe5614f9b978162abc8903faf568.png) ---
**Author:** ![leonard.moelders](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/leonard.moelders/32/108216_2.png) [@leonard.moelders](https://forum.dynamobim.com/u/leonard.moelders)\ **Post date:** [September 27, 2022, 6:00am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/32 "2022-09-27T06:00:41Z")
Just out of curiosity: The import of data from excel does not work on my machine, if the excel-file is in a folder that is synched by microsoft’s OneDrive. I always need to pause the synchronisation of OneDrive-Folders before I start my dynamo-script. Does anybody else have this problem? I mean it’s easily solved by pausing OneDrive, but still it’s annoying. ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [September 27, 2022, 6:29am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/33 "2022-09-27T06:29:03Z")
Does it work if you use Bumblebee for read and write ? ---
**Author:** ![leonard.moelders](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/leonard.moelders/32/108216_2.png) [@leonard.moelders](https://forum.dynamobim.com/u/leonard.moelders)\ **Post date:** [September 27, 2022, 6:35am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/34 "2022-09-27T06:35:09Z")
Never tried, as we are not allowed to use packages in our company. 😕 ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [September 27, 2022, 6:40am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/35 "2022-09-27T06:40:50Z")
allright if so you could see how Konrad has do it and make your own node as it written in python i think;) anyway bumblebee seems to work without issues at least for me 😉 ---
**Author:** ![leonard.moelders](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/leonard.moelders/32/108216_2.png) [@leonard.moelders](https://forum.dynamobim.com/u/leonard.moelders)\ **Post date:** [September 27, 2022, 7:31am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/36 "2022-09-27T07:31:12Z")
Unfortunately its not written in python, but I maybe implement a python node, which checks if OneDrive is running and if so kills it via os.system("taskkill /f /im “killthisprogramm.exe”) before reading the excel file. ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [September 27, 2022, 7:36am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/37 "2022-09-27T07:36:43Z")
Killing onedrive is a bad idea unless you restart it when you’re done. This is because a LOT of Microsoft’s tools rely on that running to ensure things don’t fall out of sync. You might be able to circumvent the inevitable “oh I was editing that word doc and forgot that it wasn’t syncing and you didn’t even get to notice I was in it” version conflict by copying the file to another location (say the user’s active temp directory), update the data in that file, overwrite the file in the onedrive directory with the new file version, and remove the temp file. ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [September 27, 2022, 8:01am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/38 "2022-09-27T08:01:12Z")
very strange both read and write is written in python in my version I use that version there fit 2022 ---
**Author:** ![leonard.moelders](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/leonard.moelders/32/108216_2.png) [@leonard.moelders](https://forum.dynamobim.com/u/leonard.moelders)\ **Post date:** [September 27, 2022, 8:04am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/39 "2022-09-27T08:04:38Z")
Sorry, I meant that it’s not available in the github repository as python code. ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [September 27, 2022, 8:06am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/40 "2022-09-27T08:06:07Z")
arhh ok ---
**Author:** ![leonard.moelders](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/leonard.moelders/32/108216_2.png) [@leonard.moelders](https://forum.dynamobim.com/u/leonard.moelders)\ **Post date:** [September 27, 2022, 8:12am UTC](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417/41 "2022-09-27T08:12:40Z")
I know, but at the moment I’m already pausing the synchronisation everytime a script needs to load an excel-file…So: ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/d/fdd8b2de8536093b0417792ed57eaba614193891.jpeg) The files on my OneDrive are only used by me, as I use OneDrive only as my backup-folder. That Problem was not always there, maybe OneDrive had an update which caused these issues. FYI: I am still using Revit 2019 😅 [Previous page](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417.md?page=1) [Next page](https://forum.dynamobim.com/t/data-importexcel-operation-failed/27417.md?page=3)