Forum Discussion
PopTart031790
Aug 30, 2023Copper Contributor
Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,",","!",2))-1)
Fill Down is not changing the value in formula =LEFT(H13,FIND("!",SUBSTITUTE(H13,",","!",2))-1) I have checked the copy down tab is on. No locked values in my formula. Simply trying to get rid ...
- Aug 30, 2023
You can check if calculation options are set as manual with this path:
Formulas -> Caluculation options -> Manual
If so, change Manual to Automatic.
HansVogelaar
MVP
Check that Calculation Options in the Calculation group of the Formulas tab of the ribbon is set to Automatic.
PopTart031790
Aug 30, 2023Copper Contributor
You were exactly right - it was set to manual instead of automatic. Thanks for the quick response!