>My bug that I found has to do with Excel 2016. At my company, we have many spreadsheets that use a feature in Excel called “Web Queries“. These allow one to download a web page, or a table that is on the web page, into cells in your excel document.
Ok, sounds janky, but go on...
>In my particular case, I am using this feature to connect our internal job tracking system that I developed to spreadsheets that are used for calculating pricing and energy savings (our company makes energy savings updates to refrigeration systems), and upload that result back to the tracking system.
Oh god why?? Why!?? What is this Frankenstein system you have created??
It's... complicated :) Mostly because utility companies insist on Excel for exchange of energy calculations. And even more importantly, because it was WAY WAY better than the previous iteration. Don't make me talk about it.
You can use actual programming languages to beat up excel: http://www.python-excel.org/ (I'm sure other languages can beat up excel too)
I'm not saying it's a fix for this particular use case, but I couldn't imagine having to manually update a bunch of excel sheets regularly.. talk about a nightmare. ack.
I feel your pain and too don't want to talk about it, the problem is the software 'corporates' think they should be using isn't what they should be using due to people in non-technical roles making technical decisions.
Because anyone can edit, and probably understand, it. Same reason hedge funds and banks calculate so much through Excel. Contrast that with a service which someone has to maintain, keep up to date, document, et cetera.
Ok, sounds janky, but go on...
>In my particular case, I am using this feature to connect our internal job tracking system that I developed to spreadsheets that are used for calculating pricing and energy savings (our company makes energy savings updates to refrigeration systems), and upload that result back to the tracking system.
Oh god why?? Why!?? What is this Frankenstein system you have created??