Forum Discussion
Stockhistory function is suddenly blocked
- No update on how and when it will be resolved. But I've a work around that you can do - save the excel in one drive and then using the one drive URL of excel open it on a browser. It will work fine.
StockHistory function still broken on both web and regular versions of Excel, sadly.
Keeping fingers crossed.
Are you able to use yours?
It seems that now StockHistory works!
But I have it wrapped with SumProduct and that function is causing the error now, when it worked just fine before.
Oh yes, I used SumProduct because Excel returned it as an array, not as a number, therefore SumProduct was necessary to make the quote usable.
They didn't change the description of the command on their knowledge base. Is excel behavior going to change and we're supposed to edit our spreadsheets to account for it?
I will need to check why I was using SumProduct to wrap it, I likely fixed another issue following advice from someone on line a very long time ago. 😬
But that's good, nonetheless.
It's not the SumProduct Formula being broken
Weirdly enough, if I open a cell, edit it (even to insert an error), then edit it back, it works.
- Found a solution!
Open the spreadsheet broken.
Use, on your keyboard, Ctrl + Alt + F9
That forces excel to recalculate everything and fixes it. :fireworks::fireworks::fireworks:
- Are you able to use yours? <<< Yes, I am able to use the function, back to normal life 🙂
I have not used the sumproduct function, so I am unable to say much.
Thank you.Yes, I can use StockHistory but instead of returning an array it's returning a value. That means I am unable to wrap it with SumProduct.
I will batch edit my entire spreadsheet to be able to work, and if necessary I'll change it back later. 🤪