Excel 2016 formulas not updating
it looks to me like the issue is your reference numbers in column A are fixed so when you delete those two rows your numbering gets mixed up because your final percentage is based on the reference numbers being pulled over into your formula in column L. I've just updated to Excel 2016, and found that my relative formulas aren't working properly any more.For example, if I delete row 10, the new E10 (which was E11=E10 C11-D11) is now E10=#REF! I'm shocked that in at least 15 years of using Excel I haven't run into this situation before. In this short tutorial, you will learn an easy way to display formulas in Excel 2016, 2013, 2010 and older versions.hi please help when i delete 2 rows my formulas do not add up to 100%, what can the reason be?i attached a example, the formulas are in columns j-L I added all the ones in column c, in row c313 there is a total percentage of 100%, if i delete rows 225 & 226 the percentage in c313 is 99% but it must be 100%?In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update automatically. Select the data range and click Table under Insert tab, see screenshot: 2.
The only way the to update the cell is to click on the formula and hit Enter or Tab.i attached the workbook cell a307 = 201 (manualy input).If you delete 2 rows its should be (201 -/- 2) = 199 You divide by 201 instead of 199, so that is why you don't get 100%.The solution will be to use a formula that counts the answered questions.
In that case you caused a trouble merging rows (278 - 307) column B and C.Supposing you have created a chart to track the daily sales based on a range of data in your workbook.