Not just the area with the cells, but the area with the ribbon, and everything else. If I click in the area with the maximize/minimize buttons, sometimes the window will respond by changing size, but sometimes it won't.
If I click the area with the close button, usually I will get the popup asking me if I want to save or not.
I can save as an Excel file (200K) without trouble.
At some point, within the first few minutes, the Excel window will stop updating.
If the data comes from an external data source, the workbook author or administrator has defined the connection information, often in an Office data connection (.odc) file, which describes how to locate, log in, query, and access the external data source. Top of Page When you are connected to an external data source and you attempt to refresh the data, it's important to be aware of potential security issues, and to know what you can do about any security issues.
When you are connected to an external data source, you can perform a refresh operation to retrieve the updated data. A connection, often saved to a connection file, defines all the information needed to access and retrieve data from an external data source. There are a variety of data sources you can access, such as OLAP, SQL Server, OLEDB providers, and ODBC drivers. A data connection file often contains one or more queries that are used to refresh external data.
Allerdings bin ich mir jetzt nicht sicher ob das unbedingt Rechenzeigt spart.
The following sentence will turn offthe screen updating : Application.
Screenupdating = False It's not necessary to turn on the screen updating.
I also have had this problem with a very large spreadsheet that just stopped updating itself over the weekend, but having checked the above solutions, setting were already set to automatic, and sheet is too big to rebuild, so I was at a loss.
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.