So instead lets roll up our sleeves and find out the reason for this mishap.You may have set the cell formatting to “Text” and then typed the formula in it. Refreshing the workbook or sheet also does not work. : The value returned by your Excel formula does not update automatically, i.e.I am using apache POI to change cells in an excel sheet.After I change the values, the cells with formulas corresponding to cells that have been changed are not updating.
Stack Exchange network consists of 173 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. (Alternatively you can press F2 and then Enter after setting format to General). My solution was to find an old version of the same excel spreadsheet which was not having thses issuesbefore I archived it, which is of similar size and complexity to the current version.I opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. In my instance I was using a particular add-in called PI Datalink.Somehow PI's Calculate method was no longer running during the normal workbook recalculate.In Settings I had to change Automatic Update command to Full Calculate and then back again.Does anybody no how to get Excel to automatically recalculte formuals after a formating change? Therefore, it will not recalculate the worksheet, nor will it trigger a Worksheet_Change event procedure.This means that the values returned by these functions may not be correct immediately after you change the color of a cell.the formula continues to show the old value even after you’ve changed the values of the dependent cells.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.