Values in excel not updating
This file format (.prn) saves only the text and values as they are displayed in cells of the active worksheet.If a row of cells contains more than 240 characters, any characters beyond 240 wrap to a new line at the end of the converted file.If cells display formulas instead of formula values, the formulas are saved as text.To preserve the formulas if you reopen the file in Excel, select the Delimited option in the Text Import Wizard, and select tab characters as the delimiters.If you frequently share workbook data with people who use an earlier version of Excel, you can work in Compatibility Mode to prevent the loss of data and fidelity when the workbook is opened in the earlier version of Excel, or you can use converters that help you transition the data.For more information, see Save an Excel workbook for compatibility with earlier versions of Excel.The data displayed in the current view of a Pivot Table report is saved; all other Pivot Table data is lost.
Columns of data are separated by commas, and each row of data ends in a carriage return.
Page setup settings and manual page breaks are lost.
Cell comments, graphics, embedded charts, objects, form controls, hyperlinks, data validation settings, conditional formatting, and other worksheet features are lost.
Note: If your workbook contains special font characters, such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system.
For example, if you are using Microsoft Windows and want to use the text file on a Macintosh computer, save the file in the Text (Macintosh) format.