Hello fellow space tycoons,
can someone please tell me how i can get the data in the EVE online Excel Add in to update?
Does not happen when i open the spreadsheet, does not happen when i click refresh data, there is no “refresh” button in the Add in window etc. Seems like they forgot to build in a function to update the data?
Eveytime i open the sheet it shows the orders i had when i started to build the sheet not the actual ones.
I d highly appreciate help. thx.
For the emperor!
Interact with the cell that you want to update, and hit enter, that will recalculate it.
You can also do shortcuts to update all cells. Ctrl + Alt + F9
The way it worked before a patch from Microsoft was that everything would update when opening the workbook, but it caused a lot of load on startup for large sheets so it was removed. The addin can’t know which cells to update for you if we had a button in the sidebar so the user has to manage their own updates either via manual cell interactions or the update all shortcut.
Hope this helps!
I’m having a similar problem. I don’t know anything about spreadsheets or Excel but I wanted to try it out and maybe learn something. I am using the free version of Excel on the web to see if it’s worth investing in. So upon creating a workbook and grabbing the Add-In all of my Data “Loaded” but it didn’t even load from the current state, it loaded information from a few days prior, I could see this by my Biography. After saving and quitting, if I try to access the workbook again I am given an error that “Something Went Wrong.” I have tried on both my computer browser and mobile browser. 
As long as the addin it installed it should behave on start in excel web, since the addin doesn’t “update” the data until it is interacted with, so excel web should get enough time to load it in properly.
If you have some steps I can try to follow to see the behaviour that’d be great.
Like 1. Create sheet with a character cell and character_orders. 2. close the window, 3. reopen the sheet 4. ??? 5. see error
Hey, thanks! I would really appreciate that. I can tell you what I first did.
On my web browser I went to Excel and logged in to my Microsoft Account.
Following the instructions on EVE’s website for the Add-In:
I created a workbook.
I installed the EVE Add-In.
The Character Page (I can’t remember the exact title as I am not currently looking at it) is the only function(?) that would perform and when it did it loaded information from a couple days in the game prior to the day I was doing all of this, not the current data I would have expected to see. Like, how in the hell is it grabbing old data from a live server? It didn’t make sense to me but I’m also not a tech guy so whatever.
I tried every other category or function (I really don’t know the proper terminology for all of this, this is all new for me) that was immediately available on the right panel where the Add-In is displayed but nothing would work. I don’t recall the exact syntax(?) but it seems to me it was a single word similar to < nothing >.
So anyway I saved the workbook and quit hoping if I came back to it later it would magically be fixed. Not only was it not fixed but Excel itself sent me to a blank white page that says “Something isn’t right.” This happened with two other blank workbooks I created as well when testing things out so I don’t think that much at least is an EVE related issue.
So moving forward, tomorrow morning when I am at my computer I will try again and do my best to document or screenshot the steps I take before posting again here so, at your leisure and convenience, you can check it out.
Now as far as what you mentioned about updating, that much I had read. That it only populates and updates AS I use it on the web by moving between the boxes and such and not in real-time. I’m okay with this because as I said at this time I am just trying to feel it all out. I simply wasn’t able to really get off the ground with it which is a bummer.
Thanks again!
In this post you can see where I sign in to Excel, view my Workbook with the EVE Add-In, and receive an error when attempting to access it. The only way I am able to delete workbooks I create is by opening Microsoft Onedrive and deleting it from there. I am going to do so and in my following post will show the steps I go through when creating another Workbook with the EVE Add-In.
To my surprise after creating a new Workbook most Functions now perform. I even closed my Workbook and am able to successfully open it again. However, some Functions are still not performing. I have not tested every single one but I don’t mind doing so if it would be helpful. In these screenshots can be seen how the Assets Function is not performing. I tried doing so without an active session on EVE as well as with an active session, I also tried signing out and in on Excel during my active session on EVE.
Same here. I had a sheet that worked perfectly. But looking to the formulas, they are different from what they used to be. Probably related with the last update as it’s the first time that I have this issue.
That asset function seems to be returning N/A which means it didn’t find any Rifters, as per the filter applied. When filtering via exact matching name or a valid type_id the asset function will prefilter.
Do you perchance not own any Rifters? 
And the naming corruption, that Chloe describes, is something the addin store triggered by prompting a reinstall of the manifest(the file that describes the addin) that leads to a uncontrolled unlinking of the functions in older sheets. It loses context of what addin its connected to and adds jibberish at the front of the normal =EVEONLINE. schema. Should be able to replaceAll fix it, or manually editing the text. Not much we can do there to help with that.
Okay, it seems I didn’t understand. I assumed Assets returns all Assets. I don’t actually know what a Rifter is. So perhaps moving forward I’ll try to examine these more closely. Perhaps everything now is working as it should. I’ll reply here if I have any trouble.
