Forum Discussion
Formulas
I am MS 365 Family user. Sometimes formulas work but if I touch it w/o changes it stops working. Could someone please point me in the right direction to help me understand how to add, get int...
Thanks for responding back to me.
The attached excel file is the spreadsheet that does not work for me. Are you not receiving the attachment or is the file corrupt?
Any help would be appreciated.
Steve Lorentzen
stevelorentzen@comcast.net
The attached excel file is the spreadsheet that does not work for me. Are you not receiving the attachment or is the file corrupt?
Any help would be appreciated.
Steve Lorentzen
stevelorentzen@comcast.net
The sheet updated fjust fine for me. Still worked when I introduced names to avoid relative referencing.
= STOCKHISTORY(Stock, Date, Date, 0, 0, 1) * Qty
The formula spilt as an dynamic array without issue.
- Peter, thanks for the reply. Unfortunately for me I'll need more info. Could you spell out in detail how you go about making it update. Assume I know nothing about working with spreadsheets (which is pretty much true). Spell out like left click on cell b48 press enter, ctrl enter, f4, or whatever. There is something in my knowledge that I am missing in working with cells or formulas that is preventing me from making this work. Something will click for me that will help me to solve my problem.
Thanks for your help.
Steve Lorentzen
stevelorentzen@comcast.netSorry but, for me, the formula just works.
There may be issues with the version of 365 or its update status but others are more qualified than I to comment. JKPieterse
- Your attached file works fine for me, can you show us *exactly* what isn't working as you expect it to?
