Stock Feature Is Not Working

Occasional Contributor

Hey guys, I am not sure whether it is excel version problem, I have created an excel with the use of stock data feature. However, when I share this file to my friends, they are unable to use it as their excel do not have stock feature or it has? It appears to be #VALUE or #UNKNOWN as shown in the pictures below. 

excel 2.jfifexcel 1.jfif


Anyone knows what cause it to be and how to solve it in this case? 

1 Reply



Assuming it's the STOCKHISTORY function you're using, it's only available in certain versions of Excel.