# Any details on the new excel integration? **URL:** \ **Category:** General Discussion\ **Created:** [June 16, 2023, 8:34pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561 "2023-06-16T20:34:43Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Damhest](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/damhest/32/375830_2.png) [@Damhest](https://forums.eveonline.com/u/Damhest)\ **Post date:** [June 20, 2023, 5:00pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/21 "2023-06-20T17:00:44Z")
Looks like i’m running Volume-Licensed Office 2019, so no luck for me. ---
**Author:** ![Benjamin\_Rushing](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/benjamin_rushing/32/373848_2.png) [@Benjamin\_Rushing](https://forums.eveonline.com/u/Benjamin_Rushing)\ **Post date:** [June 20, 2023, 6:50pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/22 "2023-06-20T18:50:09Z")
I just found that : ![image](https://global.discourse-cdn.com/eveonline/original/4X/9/0/d/90d3fbe6bc079bffa996f6773f4710982aeea0b5.png) ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 20, 2023, 7:26pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/23 "2023-06-20T19:26:05Z")
Yes it inserts the formula ```auto =EVEONLINE.SEARCHSOLARSYSTEM() ``` (I showed earlier in the edit of my post) into the active cell in the worksheet 🙂 if you start typying ```auto =eveon ``` into the formula box, the built in formula completion will display the list of all the available functions from EVE Online Add-in ![image](https://global.discourse-cdn.com/eveonline/original/4X/1/8/0/1804f38d44fb842e24502f8d72f37749d053234e.png) ---
**Author:** ![Lola\_Nira](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/lola_nira/32/375873_2.png) [@Lola\_Nira](https://forums.eveonline.com/u/Lola_Nira)\ **Post date:** [June 20, 2023, 8:33pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/24 "2023-06-20T20:33:04Z")
It says ![image](https://global.discourse-cdn.com/eveonline/original/4X/2/b/f/2bfa4f94a11a6fbfea953922c842860d9bd127c6.png) what to do next? ---
**Author:** ![Xirin](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/xirin/32/375878_2.png) [@Xirin](https://forums.eveonline.com/u/Xirin)\ **Post date:** [June 20, 2023, 9:05pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/25 "2023-06-20T21:05:28Z")
Same issue. Running stand-alone Excel 2016. All `=EVEONLINE` functions just yield `#NAME?` ---
**Author:** ![Caitlin\_Arsten](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/caitlin_arsten/32/375748_2.png) [@Caitlin\_Arsten](https://forums.eveonline.com/u/Caitlin_Arsten)\ **Post date:** [June 20, 2023, 9:12pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/26 "2023-06-20T21:12:26Z")
So MS Office Professional Plus 2021 is not supported? Would that fall under retail perpetual Office 2016 and later? ---
**Author:** ![Juno\_Xi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/juno_xi/32/504526_2.png) [@Juno\_Xi](https://forums.eveonline.com/u/Juno_Xi)\ **Post date:** [June 20, 2023, 9:23pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/27 "2023-06-20T21:23:50Z")
I’m running Microsoft Office Home and Student 2021. No data is being loaded through the addon. Same steps works perfectly if I go through the web version so I’m not doing anything wrong. ‘retail perpetual Office 2016 and later’ should include the standalone 2021 version right? ---
**Author:** ![Senda\_Yotsala](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/senda_yotsala/32/403082_2.png) [@Senda\_Yotsala](https://forums.eveonline.com/u/Senda_Yotsala)\ **Post date:** [June 21, 2023, 12:36am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/28 "2023-06-21T00:36:17Z")
Has anyone been able to get the Corporation Contract returning data. I’ve tried multiple times and only ever get as far as a #VALUE return. ---
**Author:** ![Calmar\_Arundel](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/calmar_arundel/32/375888_2.png) [@Calmar\_Arundel](https://forums.eveonline.com/u/Calmar_Arundel)\ **Post date:** [June 21, 2023, 12:38am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/29 "2023-06-21T00:38:11Z")
For anyone having trouble getting this to install on Office 365 because your Add-in window is blank: ![image](https://global.discourse-cdn.com/eveonline/original/4X/5/a/c/5acb93bf5c8f7b0d7d18299b2c983606c7cc2031.jpeg) > [@Version 21.05 - General Feedback](https://forums.eveonline.com/t/version-21-05-general-feedback/408965/185): > > I managed to get it installed. I could find no instructions on how to enable this, so I will share: Click on the “File” tab, In the new window that opens, click on “Account” near the bottom left corner. In the new window find “Account Privacy” just below your user information on the top left. Click on the “Manage Settings” button. A new privacy window opens. Select the “Turn on optional connected experiences” check box near the bottom of the window. Click the “OK” button in the bottom righ… ---
**Author:** ![Elinore\_en\_Divalone](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elinore_en_divalone/32/507815_2.png) [@Elinore\_en\_Divalone](https://forums.eveonline.com/u/Elinore_en_Divalone)\ **Post date:** [June 21, 2023, 6:12am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/30 "2023-06-21T06:12:18Z")
Have you tried entering this formula this way? ```auto =EVEONLINE.CORPORATION_CONTRACTS(EVEONLINE.ACTIVE_CHARACTER().corporation.id) ``` if your corp has no contracts you will get `#N/A` error > The #N/A error generally indicates that a formula can’t find what it’s been asked to look for. if you entered something like this, without providing `character_or_entity_id` parameter value ```auto =EVEONLINE.CORPORATION_CONTRACTS() ``` you will get `#VALUE` error > #VALUE is Excel’s way of saying, “There’s something wrong with the way your formula is typed. Or, there’s something wrong with the cells you are referencing.” The error is very general, and it can be hard to find the exact cause of it. EDIT: @Senda_Yotsala you are right it doesn’t work neither way it’s being used (with corp id or without) 😕 @CCP_Swift any idea what can be the cause? EDIT2: I was checking my other character corp contracts, but funny thing I have managed to create an _empty_ corp contract for items exchange so it could be the cause of not showing in formula results. Will try to create a valid corp contract and will let you know. ---
**Author:** ![Fuliare\_Cescada](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fuliare_cescada/32/465226_2.png) [@Fuliare\_Cescada](https://forums.eveonline.com/u/Fuliare_Cescada)\ **Post date:** [June 21, 2023, 9:50am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/31 "2023-06-21T09:50:19Z")
Using Microsoft 365, it took over 15 minutes to list my Market Orders for a single toon. Last night I tried for 6 hours to get my Assets listed. At best, Excel kept showing `#BUSY! `for hours on end. At worst, I got into a cycle of errors (“Sorry, something went wrong”, “Sorry, we can’t get that data right now”). Totally unusable for me in its current state (which I find highly frustrating, if I had enough disk space for Visual Studio I would have programmed my own solution years ago, as I very much want to get actual insights in my Assets and transactions - something the Eve client doesnt really offer). ---
**Author:** ![Ramona\_McCandless](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ramona_mccandless/32/468438_2.png) [@Ramona\_McCandless](https://forums.eveonline.com/u/Ramona_McCandless)\ **Post date:** [June 21, 2023, 9:59am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/32 "2023-06-21T09:59:36Z")
I thought this was going to be Excel IN EvE. What a waste of time. Tell MS thanks but Im still not paying them anything. _throws it out the window_ ---
**Author:** ![Fuliare\_Cescada](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fuliare_cescada/32/465226_2.png) [@Fuliare\_Cescada](https://forums.eveonline.com/u/Fuliare_Cescada)\ **Post date:** [June 21, 2023, 10:04am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/33 "2023-06-21T10:04:26Z")
> [@Ramona\_McCandless](#): > > Tell MS thanks but Im still not paying them anything. You can use the free Micrsoft 365 web app, according to CCP (I’m having major problems retrieving data with it though, beyond trivially small datasets) ---
**Author:** ![Ramona\_McCandless](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ramona_mccandless/32/468438_2.png) [@Ramona\_McCandless](https://forums.eveonline.com/u/Ramona_McCandless)\ **Post date:** [June 21, 2023, 10:06am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/34 "2023-06-21T10:06:19Z")
Yeah, but Im not a fan tbh. Id just liked to have full SS capability within the GUI. But thats beyond CCP these days I think ---
**Author:** ![Io\_Koval](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/io_koval/32/282426_2.png) [@Io\_Koval](https://forums.eveonline.com/u/Io_Koval)\ **Post date:** [June 21, 2023, 10:21am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/35 "2023-06-21T10:21:18Z")
They got rid of the in game browser and in game jukebox, I would be surprised at an in game spreadsheet. ---
**Author:** ![Ramona\_McCandless](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ramona_mccandless/32/468438_2.png) [@Ramona\_McCandless](https://forums.eveonline.com/u/Ramona_McCandless)\ **Post date:** [June 21, 2023, 10:23am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/36 "2023-06-21T10:23:10Z")
Two more things that made the start of Second Decade already better than start of Third And yes I know the reasons, but you know. Integration is ammunition. No, its half the battle Wait… no… Ach like CCP I got disinterested in improving myself there. ---
**Author:** ![Fuliare\_Cescada](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fuliare_cescada/32/465226_2.png) [@Fuliare\_Cescada](https://forums.eveonline.com/u/Fuliare_Cescada)\ **Post date:** [June 21, 2023, 11:26am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/37 "2023-06-21T11:26:00Z")
My latest attempt to retrieve Assets of a single toon: after hours of `#BUSY!`, downtime struck, and now I cannot even see the left part of Excel’s GUI. ---
**Author:** ![Fuliare\_Cescada](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fuliare_cescada/32/465226_2.png) [@Fuliare\_Cescada](https://forums.eveonline.com/u/Fuliare_Cescada)\ **Post date:** [June 21, 2023, 11:37am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/38 "2023-06-21T11:37:16Z")
Whenever I reload a saved spreadsheet, I’m asked to grant the Add-in permission _again_. After that, Excel starts a cycle of throwing errors and re-loading the spreadsheet (last time, I managed to stop that by pseudo-editing the formula and hitting Enter, once the Add-in was properly loaded - then it went back to `#BUSY!`, as data retrieval seems to be too slow to ever retrieve my Assets). (Microsoft 365 web app) ---
**Author:** ![Ming\_Shou](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ming_shou/32/375979_2.png) [@Ming\_Shou](https://forums.eveonline.com/u/Ming_Shou)\ **Post date:** [June 21, 2023, 2:12pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/39 "2023-06-21T14:12:41Z")
Well, in this statement > Excel custom functions are available on the following platforms. > Office on Windows > Microsoft 365 subscription > retail perpetual Office 2016 and later something should be wrong: ![rt](https://global.discourse-cdn.com/eveonline/original/4X/d/f/b/dfb0ef0e9ac51067a11f6ad04e2b923df198f286.jpeg) including the consequences, aka the #NAME error in custom functions. ---
**Author:** ![Fuliare\_Cescada](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/fuliare_cescada/32/465226_2.png) [@Fuliare\_Cescada](https://forums.eveonline.com/u/Fuliare_Cescada)\ **Post date:** [June 21, 2023, 2:22pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/40 "2023-06-21T14:22:08Z")
My latest attempt to retrieve Assets of a single toon: after 3 hours of `#BUSY!` , Excel now says `#NAME?` (Microsoft 365 web app) [Previous page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=1) [Next page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=3)