# About the EVE x Microsoft Excel Add-in category **URL:** \ **Category:** EVE x Microsoft Excel Add-in\ **Created:** [July 17, 2023, 2:23pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918 "2023-07-17T14:23:51Z")\ **Posts on this page:** 11\ **Page:** 2
**Author:** ![Fedo\_Foutou](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fedo_foutou/32/453520_2.png) [@Fedo\_Foutou](https://forums.eveonline.com/u/Fedo_Foutou)\ **Post date:** [August 7, 2023, 4:30pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/21 "2023-08-07T16:30:52Z")
None of the functions work ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [August 10, 2023, 3:24pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/22 "2023-08-10T15:24:16Z")
The latest info I have is that the Excel team is expecting to release a conclusion and solution to this issue this month. What that will be exactly I can’t know for sure. Hopefully it’s going to be support for retail excel or some way for us to update the add-in to include support. But I can’t know for sure. ---
**Author:** ![Fedo\_Foutou](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fedo_foutou/32/453520_2.png) [@Fedo\_Foutou](https://forums.eveonline.com/u/Fedo_Foutou)\ **Post date:** [August 20, 2023, 5:51pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/23 "2023-08-20T17:51:17Z")
Hundasuupa This is great news. Thanks for the update. ---
**Author:** ![pradamours](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/pradamours/32/419052_2.png) [@pradamours](https://forums.eveonline.com/u/pradamours)\ **Post date:** [August 30, 2023, 4:11pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/24 "2023-08-30T16:11:33Z")
Hey. I would like to list all my assets. But the command “=EVEONLINE.CHARACTER\_ASSETS()” doesn’t work. What can I do? ---
**Author:** ![Elzig\_Gloomyness](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elzig_gloomyness/32/380919_2.png) [@Elzig\_Gloomyness](https://forums.eveonline.com/u/Elzig_Gloomyness)\ **Post date:** [August 30, 2023, 7:36pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/25 "2023-08-30T19:36:54Z")
Seems like you need the character to get the list, `=EVEONLINE.CHARACTER_ASSETS(INDEX(EVEONLINE.ACTIVE_CHARACTER(),3))` should get you the 3 active character. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [August 30, 2023, 11:53pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/26 "2023-08-30T23:53:45Z")
Like Elzig said you can use a character\_id to display it. It’s the first optional parameter. You can inject into the character\_id\_or\_entity parameter the cell from the active character list, or the functions dropdown in the sidebar for your logged in character, assets button in there will inject into your selected cell in the sheet the preset character\_assets function with the character\_id and the “Rifter” filter for an example of type\_name\_or\_type\_id parameter being applied. (character\_id, type\_id\_or\_type\_name, location\_filter, page) is the order of parameters There is also a location\_filter parameter, that will only display things in certain stations or containers if you supply their IDs, the jita 4-4 being a popular choice `=EVEONLINE.CHARACTER_ASSETS(,,60003760)` being all items for all logged in characters in Jita 4-4. `=EVEONLINE.CHARACTER_ASSETS(,32872)` returns all your Algos. `=EVEONLINE.CHARACTER_ASSETS(,34,60003760)` returns all your trit IN jita 4-4. If it’s in containers it should expose it per container etc. However if you call the function like you commented, without a parameter supplied, it will fetch all logged in characters assets. It can take very long to do so if you have a lot of items, and even longer if they are in many different private structures. So having either paging or type\_id/location\_filter helps the performance a ton! Sidenote: if you are on excel web, you might very likely get a forever #BUSY due to a payload size limit in web excel unless you use the pagination parameter that will split up the assets results into pages. (500 per page) `=EVEONLINE.CHARACTER_ASSETS(,,,1)` if you have “,” as your excel seperator can help you display your items in excel web. What exactly the error from the cell was would help us and if you were on web or a desktop client , if my message is getting to technical 👏 ---
**Author:** ![Threv\_Echandari](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/threv_echandari/32/395366_2.png) [@Threv\_Echandari](https://forums.eveonline.com/u/Threv_Echandari)\ **Post date:** [December 3, 2023, 4:43pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/27 "2023-12-03T16:43:12Z")
Can Corp Projects be added as Function? Definitely need tracking on that. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [December 4, 2023, 3:51pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/28 "2023-12-04T15:51:34Z")
Once it’s been exposed in the ESI that’s def doable 🙏 ---
**Author:** ![Fedo\_Foutou](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fedo_foutou/32/453520_2.png) [@Fedo\_Foutou](https://forums.eveonline.com/u/Fedo_Foutou)\ **Post date:** [December 11, 2023, 6:31pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/29 "2023-12-11T18:31:29Z")
Has the issue I started this post with been addressed? Last time I checked I still couldn’t get the add-on to work. ---
**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\ **Post date:** [December 11, 2023, 11:54pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/30 "2023-12-11T23:54:13Z")
> [@Retail Excel 2019/2021 Compatibility Update](https://forums.eveonline.com/t/retail-excel-2019-2021-compatibility-update/420269): > > Hey guys, Initially we reported to Microsoft that the addin’s framework checks we used to detect if the Excel client could run the add-in wasn’t working properly for retail excel users. The checks said yes, but the functions didn’t work, #VALUE errors etc. They’ve looked into it and the conclusion is, that due to business concern, they can’t bring compatibility of rich data type features to non-subscription users of Excel. They are fixing the way the add-in can detect compatibility so at lea… in short, M365 is required for the desktop version. 2019/2021 did not get the features required. ---
**Author:** ![Bao\_Chi\_Sandival](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bao_chi_sandival/32/421680_2.png) [@Bao\_Chi\_Sandival](https://forums.eveonline.com/u/Bao_Chi_Sandival)\ **Post date:** [December 18, 2023, 8:48pm UTC](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918/31 "2023-12-18T20:48:58Z")
So basically, the Excel Add-on will likely be useless to anyone who doesn’t have Microsoft’s endless Annual software subscription. I’m not blaming CCP here, but I am not entirely surprised that any collaboration with Microsoft would end up requiring the Annual Subscription version of Excel in order for the Add-on to work. [Previous page](https://forums.eveonline.com/t/about-the-eve-x-microsoft-excel-add-in-category/412918.md?page=1)