Forum Discussion

fi10's avatar
fi10
Copper Contributor
Nov 29, 2023

Stockhistory SharePoint

Hello,

I am wondering if the stockhistory function is not available in SharePoint? 
I uploaded an Excel file to SharePoint yesterday and it seemed to work well.
Today, I opened the file online, and it appears the #blocked! in stockhistory functions.   It said it has to be a required license, however, I already signed in to the subscribed account online.  

Is there any way to resolve it?

Thank you!!

 

excel
Excel for web
Formulas and Functions

1 Reply

  • Harrhnson's avatar
    Harrhnson
    Iron Contributor
    Jul 17, 2025

    With Excel's = STOCKHISTORY () function, you have to make sure that the data source is a SharePoint online file and that you have enabled external data connection permissions.