Jul 01 2019 07:45 AM
I recently tride to input new data into a worksheet and it no longer will sum the total information.
The sheet is unprotected, curious what the issue might be to get the formulas to populate the results of additional data entered? Where would I look?
Thanks,
Lloyd
Jul 01 2019 07:55 AM
Jul 01 2019 08:27 AM
Thanks for the feedback. However, unfortunately the line items in question do not have the green triangle, they merely sum the totals above. Up until today it worked just fine, pretty simple excel file yet the issue is bugging me, not sure what I could have clicked to have all the sum total formuals stop updating.
Jul 02 2019 03:29 AM
Jul 02 2019 06:02 AM
Yes, somehow they got turned to manual, that fixed it.
Thanks for your help.
Lloyd