SOLVED

STOCKHISTORY Function missing from 365 enterprise

%3CLINGO-SUB%20id%3D%22lingo-sub-2362321%22%20slang%3D%22en-US%22%3ESTOCKHISTORY%20Function%20missing%20from%20365%20enterprise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2362321%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20opened%20excel%20this%20morning%2C%20all%20the%20STOCKHISTORY%20functions%20were%20replaced%20with%20_xlfn.STOCKHISTORY.%20I%20use%20365%20Apps%20for%20enterprise%20(Semi-Annual%20Enterprise%20Channel)%20and%20I%20made%20sure%20that%20my%20software%20is%20updated%20to%20the%20latest%20version.%20Any%20ideas%20on%20why%20this%20is%20happening%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2362321%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2363773%22%20slang%3D%22en-US%22%3ERe%3A%20STOCKHISTORY%20Function%20missing%20from%20365%20enterprise%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2363773%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056229%22%20target%3D%22_blank%22%3E%40EricStakebake%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAvailability%20depends%20on%20your%20subscription%20and%20version%20on%20semi-annual%20channel%20(it%20could%20be%201908%2C%202002%2C%202008).%20You%20may%20check%20in%20comments%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-stockhistory%2Fba-p%2F1404338%2Fpage%2F2%23comments%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-stockhistory%2Fba-p%2F1404338%2Fpage%2F2%23comments%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20you%20may%20expect%20it%20this%20summer%20with%20next%20feature%20update%2C%20but%20I'm%20not%20sure.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I opened excel this morning, all the STOCKHISTORY functions were replaced with _xlfn.STOCKHISTORY. I use 365 Apps for enterprise (Semi-Annual Enterprise Channel) and I made sure that my software is updated to the latest version. Any ideas on why this is happening?

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@EricStakebake 

Availability depends on your subscription and version on semi-annual channel (it could be 1908, 2002, 2008). You may check in comments here https://techcommunity.microsoft.com/t5/excel-blog/announcing-stockhistory/ba-p/1404338/page/2#commen...

 

Most probably you may expect it this summer with next feature update, but I'm not sure.

Thank you for your response, Sergei! It looks like my version is 2008. I'll keep my eye out for the July update. I just find it strange that I had access to the function last week and now it's gone.