Looks like i’m running Volume-Licensed Office 2019, so no luck for me.
2 Likes
I just found that :
1 Like
Yes it inserts the formula
=EVEONLINE.SEARCHSOLARSYSTEM()
(I showed earlier in the edit of my post) into the active cell in the worksheet 
if you start typying
=eveon
into the formula box, the built in formula completion will display the list of all the available functions from EVE Online Add-in
1 Like
It says
what to do next?
Same issue. Running stand-alone Excel 2016. All =EVEONLINE functions just yield #NAME?
1 Like
So MS Office Professional Plus 2021 is not supported?
Would that fall under retail perpetual Office 2016 and later?
1 Like
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?
2 Likes
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.
For anyone having trouble getting this to install on Office 365 because your Add-in window is blank:
1 Like
Have you tried entering this formula this way?
=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
=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.
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).
2 Likes
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
1 Like
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)
2 Likes
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
1 Like
They got rid of the in game browser and in game jukebox, I would be surprised at an in game spreadsheet.
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.
1 Like
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.
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)
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:
including the consequences, aka the #NAME error in custom functions.
1 Like
My latest attempt to retrieve Assets of a single toon:
after 3 hours of #BUSY! , Excel now says #NAME?
(Microsoft 365 web app)