I recently installed the Office 365 trial and am running an Excel sheet I have been testing.
Suddenly, anything I enter into any of the cells on one of the sheets in this document will not show up on the spreadsheet. They do however show up in the Formula Bar even after navigating away from the cell and back. This tells me that they are storing, but the sheet is not refreshing.
Furthermore, the dependant formulas do not recalculate and refresh. However, when you highlight a cell that should have recalculated, the information shown in the bottom bar of Excel such as the average of the selected cells and max/min values does update. This means that it must be calculating, but the sheet is not refreshing to show those values. Only by navigating to another sheet and back do the values appear. As far as troubleshooting. I have ensured that my document is set to automatic calculation as is suggested when this problem arises. I also made sure that it wasn't some sort of macro issue by disabling all macros and trying again. I thought that it could be something to do with not restoring sheet refreshing or something but that does not appear to be the case.
Any help is greatly appreciated.
Thank you for posting in the MSDN Forum.
According to your description, I think your issue is a non-development issue. I suggest you repost it on the Excel Answers Forum.
The experts there are more familiar with your issue and may give you more suggestions or workarounds.
Thank you for your understanding.
Quist Zhang [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
- Edited by Quist ZhangMicrosoft community contributor Monday, December 10, 2012 8:40 AM