# 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:** 3
**Author:** ![Alua\_Oresson](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/alua_oresson/32/504959_2.png) [@Alua\_Oresson](https://forums.eveonline.com/u/Alua_Oresson)\ **Post date:** [June 21, 2023, 3:56pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/41 "2023-06-21T15:56:08Z")
I believe it is 2016 and older… ---
**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, 3:58pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/42 "2023-06-21T15:58:20Z")
My latest attempt to retrieve Assets of a single toon: after 1 hour 33 minutes of `#BUSY!` , Excel now says `#NAME?` (Microsoft 365 web app) ---
**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 21, 2023, 4:19pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/43 "2023-06-21T16:19:14Z")
![2023-06-21 17_16_34-Post-Integration - Excel](https://global.discourse-cdn.com/eveonline/original/4X/a/e/3/ae3b464dc3dae241e0b2ed658bfbc4231eb14b90.png) All I’ve been able to get with a 2021 home office version. Genuine copy from the Microsoft site. Am I miss-understanding something, this should be working right? When used on the web version it actually returns values. ---
**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, 4:28pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/44 "2023-06-21T16:28:17Z")
Of course. And the MSO 2019 is older in programming terms which is demonstrated by this: ![image](https://global.discourse-cdn.com/eveonline/original/4X/5/5/7/5579152c8a36cedf73c8b204d6ba0f1febfcc83d.png) Since my Excel is v.2302 (build 16501 whatever), and it is a retail version (not VL), it should support all the functionality. Though it does not. I just recall how yesterday Oz said that in his opinion this tool will lower the barrier for entry to use spreadsheets by new players from 80% to 50%…lmao ---
**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, 5:42pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/45 "2023-06-21T17:42:30Z")
I feel for you. We, at our desktop Office suites at least get the #NAME? error immediately 🙂 ---
**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 21, 2023, 6:54pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/46 "2023-06-21T18:54:25Z")
Anyone got an idea who to translate the 13-digit number that =I2#.location\_id gives me, into the name of the actual place? ---
**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, 8:29pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/47 "2023-06-21T20:29:18Z")
Does ```auto =EVEONLINE.STATION(I2#.location_id) ``` or ```auto =EVEONLINE.STRUCTURE(I2#.location_id) ``` or ```auto =IF(ISERROR(EVEONLINE.STRUCTURE(I2#.location_id));EVEONLINE.STATION(I2#.location_id);EVEONLINE.STRUCTURE(I2#.location_id)) ``` work for you? ---
**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:10pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/48 "2023-06-21T21:10:31Z")
I tried to retrieve Wallet Transactions of a single toon: after approx. 2 hours of `#BUSY!` , Excel now says `#NAME?` (Microsoft 365 web app) I’ve spent 19 hours, all I could get was the 30-ish Market Orders of a single toon (and that took 15 minutes) 😢 ---
**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, 9:24pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/49 "2023-06-21T21:24:27Z")
Closing down and reopening workseet (and Excel) helped me overcome `#BUSY` state. Classic IT solution 😛 Also used _Reload_ command in the Add-in pane a few times. ---
**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 22, 2023, 12:19am UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/50 "2023-06-22T00:19:27Z")
I suppose you’re not using the Web version (as closing the worksheet also closes Excel in the web app)? Whenever I close and reopen my worksheet (containing a single call to an Add-in function) Excel goes from `#CALC!` to `#NAME?` and stays there, until I click in the formula bar with the cell selected, and hit Enter - then it goes to `#BUSY!`, as it should AFAIK while waiting for the data from Eve’s API. Same when I Reload the Add-in pane. ---
**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 22, 2023, 1:15pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/51 "2023-06-22T13:15:49Z")
CCP, anybody, any comments on this? > [@Any details on the new excel integration?](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/39): > > 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] including the consequences, aka the #NAME error in custom functions. ---
**Author:** ![ISE\_Admin](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ise_admin/32/376121_2.png) [@ISE\_Admin](https://forums.eveonline.com/u/ISE_Admin)\ **Post date:** [June 22, 2023, 3:36pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/52 "2023-06-22T15:36:23Z")
Also can’t get this to work. Any success on your end? ---
**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 22, 2023, 7:13pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/53 "2023-06-22T19:13:47Z")
Well, tbh in my eyes it seems as a complete failure on side of CCP/Microsoft whoever tested this [censored]. Really, those, who understand the power of spreadsheets would probably agree. By introducing the Excel add-in CCP was right in intent. But the way it was done completely ruined this intent. I mean that a selected few who have no issues with the add-in now are able to use its power, while others must still rely on their home-made tables with ESI-calls in best case. This gives the ones with working add-in a serious advantage, which I think I can already notice in market’s behaviour. This add-in in the hands of few can ruin the market PVP as a definition. Uff, I spoke. Sry if angered but it really made me mad. ---
**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 22, 2023, 8:04pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/54 "2023-06-22T20:04:23Z")
If you just need quick, transregional market overview for a certain item you can catch up with this handy third party EVE complementary service > **[EVEMarketer](https://evemarketer.com/)** > > EVEMarketer is market data and statistics tool for EVE Online It precedes now infamous, fussy and evil _EVE Online Excel Add-in_ ---
**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 22, 2023, 8:21pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/55 "2023-06-22T20:21:08Z")
TY, I am aware of most of the third-party eve tools, aka EveMarketer, Adam4Eve, EveMarletWatch, EveTycoon, jEveAssets etc, and I also have my own spreadsheets. What makes me mad is that this add-in would make obsolete a lot of time wasted on looking up particular info on different resources but… ---
**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 23, 2023, 6:53pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/56 "2023-06-23T18:53:59Z")
In the GESI add-on for Google Sheets, one way of doing this looks like this(with data/error checking): = IFERROR(regexextract(HLOOKUP(“systems”,universe\_ids(F2,true),2),“[0-9]+”),“NA”) This Excel implementation it is a little shorter. The difference is that in Excel you have to know which property to access in these many complicated objects, whereas using GESI you need to know which parameters to use in its many functions. Using Excel, function parameter types(data types, not Eve Online types) is not consistent and the function/object combinations are not well documented. Finding a function that extracts the data you want from an object is a bit of a safari. At first I was dismayed at functions returning objects from this large, complicated object tree; but its getting easier as I become more familiar with them. And of course, some things can be done more directly. We have access to ALL excel functions, which Google does not have. Google does have the faux SQL commands which make a lot of things easier and more straightforward for me. It’s an excellent alternative to Excel’s terrible Filter() function. ---
**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 23, 2023, 7:14pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/57 "2023-06-23T19:14:10Z")
I agree. It looks like everything in their propaganda is incorrect. 1. It IS part of a third party application. 2. It is NOT readily available to all players, unless you mean that anyone can subscribe at significant cost to use it. 3. It does not provide access to non-programmers. Have you seen the code in the cells in the demonstration workbook? This would only seem accurate for those who only use the canned worksheets. P.S. Some of the important cells never load for me, so anything that depends on them throw errors. ---
**Author:** ![Baron\_Harkonnen](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/baron_harkonnen/32/376028_2.png) [@Baron\_Harkonnen](https://forums.eveonline.com/u/Baron_Harkonnen)\ **Post date:** [June 23, 2023, 8:20pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/58 "2023-06-23T20:20:01Z")
I have found that the formulas don’t update by themselves. I created a macro which copy and pastes the formulas over themselves which seems to trigger the Add-in to refresh the cells. Cell C2 has the formula =EVEONLINE.TYPE(A2) With cells A2…A5051 having the type id’s for whatever you want to list. Sub UpdateMarket() ’ ’ UpdateMarket Macro ’ ’ Application.ScreenUpdating = False Sheets(“Market Prices”).Select Range(“C2”).Select Selection.AutoFill Destination:=Range(“C2:C5051”), Type:=xlFillDefault Range(“C2:C5051”).Select Selection.End(xlUp).Select Range(“C2”).Select Application.ScreenUpdating = True End Sub ---
**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 23, 2023, 9:17pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/59 "2023-06-23T21:17:32Z")
I use the _streaming_ formula for refreshing market orders every 5 minutes (let’s not be infogready) ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(;) ``` I also use this formula ```auto =TRANSPOSE(EVEONLINE.SEARCHREGION()) ``` to get a row with all regions in one row and each in separate column and in the next row i put that _streaming_ formula with region id from cell above like that ```auto =EVEONLINE.MARKET_ORDERS_STREAMING(A2.id;$A$1) =EVEONLINE.MARKET_ORDERS_STREAMING(C2.id;$A$1) . . . =EVEONLINE.MARKET_ORDERS_STREAMING(DG2.id;$A$1) ``` Cell A1 contains type id of the market item Row 2 contains regions Rows 3 and below contains market orders for a given region in a column, it looks like this ![image](https://global.discourse-cdn.com/eveonline/original/4X/b/5/2/b52fb9aa7f51460ae9630aa893310e7ae8a3c592.png) This is a kind of mind blowing for me every time I use it 😃 ---
**Author:** ![Baron\_Harkonnen](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/baron_harkonnen/32/376028_2.png) [@Baron\_Harkonnen](https://forums.eveonline.com/u/Baron_Harkonnen)\ **Post date:** [June 24, 2023, 12:20pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/60 "2023-06-24T12:20:04Z")
Refreshing the formulas does trigger data download from Add-in but values stayed the same. Its not working at all now #BUSY! everywhere [Previous page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=2) [Next page](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561.md?page=4)