Hi Steve, First I suggest you try to uninstall Office completely and then reinstall Office. About how to uninstall Office completely, please refer to this article: If this issue still exists, please try to create a new account of MAC and check if it works fine in new account of MAC. Any updates please let me know, I'm glad to help and follow up your reply. Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi Beth B Miller, As far as I know users got different problems about Office after upgrading to Windows 10. I suggest you try to reset file associations:.
Cells not updating automatically. On Mac: 2008: Excel Preferences > Calculation > Automatically; In some cases you may prefer to keep it set to manual, for example if there are many heavy calculations to perform. In such cases, you can simply press F9 when you want the calculations to update. These tricks are more important with the upcoming Stock data type in Excel 2016 for Office 365 customers. Normally Excel will update itself when you change a cell value. These days there are situations where cells change value but Excel does NOT update the worksheet.
Please go to Control Panel. Click Default Programs, and then click Set your default programs. Click Excel, and then click Choose default for this program. On the Set Program Associations screen, click Select All, and then click Save.
If this issue still exists, please try to repair your Office. About how to repair Office in Windows 10, please refer to this article: Hope it's helpful. Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi Steve, First I suggest you try to uninstall Office completely and then reinstall Office.
About how to uninstall Office completely, please refer to this article: If this issue still exists, please try to create a new account of MAC and check if it works fine in new account of MAC. Any updates please let me know, I'm glad to help and follow up your reply. Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. I have a similar problem.
For example, yesterday I updated some spreadsheets using Microsoft Excel for Mac Version 15.17 (151206) on a Macbook running OS X Yosemite Version 10.10.5. This morning, I can't open one of the spreadsheets on either the Macbook or a Windows PC.
Double clicking in the Finder, or opening within Excel both fail. Nothing appears. However, when I then quit Excel, it prompts me to confirm whether I want to save changes to the spreadsheet, so it is partially opening the spreadsheet. There are no error messages displayed. Rob Bell Australia Desperate. Well, a bit more searching provided an answer - the workbook is opening, but opening 'Hidden'.
So, from the Mac Excel 'Window' menu, select 'Unhide'. You may need to have a dummy workbook also open and play with Hide and Unhide.
The clue was at - thanks. Rob Bell Australia I had the same problem and up until today, my recourse was to open the Excel file in Apple Numbers. Not a perfect solution but an option. Today after reading these posts I wondered if opening the file in Excel Online would make any difference. The file opened. Saved it as a new name and I'm back up and running.
There are several ways to make Excel automatically refresh data connections and recalculate a worksheet. These tricks are more important with the upcoming Stock data type in Excel 2016 for Office 365 customers.
Normally Excel will update itself when you change a cell value. These days there are situations where cells change value but Excel does NOT update the worksheet. In other words, modern Excel has changed in ways that Microsoft hasn’t yet fully adapted to. Ideally, Excel would have an overall setting to refresh the worksheet every ‘n’ seconds or minutes.
As it stands, we need workarounds to make it happen. Here’s some situations where forcing data refresh or recalculation might be necessary or prudent.
Stock Data Type When the becomes public (it’s now in wide preview) the ability to update automatically will become more important. Users will want their worksheets to grab the latest prices automatically, something the current preview releases can’t do. Instead of having a nice automatic ‘ticker’, we’re expected to click ‘Refresh’ to get the latest prices. The Stock and Geo data types are curious beasts. They are data connections to external sources but do NOT appear as Excel Data Connections. That means you can’t setup an automatic data refresh, as you would with normal data connections. In fact, there’s no exposed controls for the Stock or Geo data types.
NOW and other volatile functions The updates to the latest date and time whenever Excel recalculates the worksheet. But if there’s nothing to make that happen, Now doesn’t change value.
Some external factor is needed to make Excel update Now and the rest of the worksheet. In other words, you should be able to glance at a worksheet and know it’s up to the second but that’s not possible with Excel ‘out of the box’. Microsoft calls NOW and similar functions ‘volatile’ because their values can change even if no other cells have changed.
Other volatile functions are Today, Randbetween, Offset and Indirect. In some situations Info, Cell and SumIf can also be volatile. Extra caution Maybe you want your worksheet to update automatically as a precaution?
Many old Excel hands remember situations where Excel hasn’t properly updated so they like the ‘belt and braces’ approach (at least occasionally). Code The standard method of forcing automatic update of Excel is a short snippet of VBA code. Here’s what we use, there are many variations on the same theme. The full code is at the bottom of the article. There are three functions. RefreshAllDataConn does the actual refreshing of data connections ( Workbooks(ThisWorkbook.Name).RefreshAll ) and we added two, optional, lines to display the last time refreshed on the bottom status bar.
If you wanted to be extra careful, add line to explicitly force recalculation. Either ActiveSheet.Calculate or the extreme Application.CalculateFull (this would slow down a large worksheet, use sparingly).
AutoRefresh run the RefreshAllDataConn sub every minute or whatever value you set on the line Application.OnTime Now + TimeValue(“00:01:00”), “AutoRefresh” WorkbookOpen an in-built Excel function that runs automatically when the worksheet is opened. In this case it starts AutoRefresh. Data Connection The disadvantage of the VBA approach is that a.xlsm worksheet is necessary (macro enabled Excel worksheet).
There can be problems sharing macro enabled files because of security concerns. The arrival of PowerQuery / Get and Transform means there’s another way to force a worksheet recalculation. It’s a workaround and not perfect, but it’s possible and doesn’t need a macro-enabled worksheet. In short, ensure that there’s a data query setup with auto-refresh.
If there isn’t a data connection, add a small one to the worksheet. Any Excel data query comes with some refresh options in the Query properties. Most of them default OFF. Refresh every nnn minutes – defaults off with 60 minutes suggested. Refresh data when opening the file Enable background refresh Refresh this connection on Refresh All The auto-refresh workaround is to create a small and practically insignificant data connection. Then configure that data connection to update every minute or whatever time you wish.
That should force the worksheet to update including the volatile functions mentioned above. Some versions of this workaround add a link to a tiny csv file on the same computer. We’ve got the same result using a data connection from a table in the worksheet. Create a small table with a single cell. The cell can have anything but we create a cell with NOW in it, for reasons we’ll explain later. Select the table then choose Data Get Data From other sources from Table/Range. The exact menu item maybe different depending on your version of Excel.
When the Query Editor opens, just Close and Load it. In the data connections pane, you’ll see a query. Right-click the query, choose properties to see the settings we need. Set the refresh rate that suits you. To be tidy, we move the source table (right) onto the same sheet at the loaded query (left). Because we used NOW in the source table cell, it’ll be easy to see when/if the worksheet has refreshed. Whenever the query auto-refreshes, the worksheet including volatile functions should also refresh.
Ideally the Stock and Geo data types should also refresh, though this feature is still in preview, so you need to check for yourself. VBA Code example Sub RefreshAllDataConn ' Refresh all Data Connections. ' This should include Stock and Geo data types, even though they aren't listed. Workbooks(ThisWorkbook.Name).RefreshAll ' Show update time on status bar to confirm.
' comment these lines out if not needed. Application.DisplayStatusBar = True Application.StatusBar = 'Refreshed at: ' & Now End Sub Sub AutoRefresh ' to run a Refresh All on the workbook every n minutes RefreshAllDataConn ' Repeat every minute or change to whatever value you prefer. Application.OnTime Now + TimeValue('00:01:00'), 'AutoRefresh' ' this is a simple example. There's no coded way to exit this function. End Sub Private Sub WorkbookOpen ' Starts the automatic refresh when the workbook is opened, ' commented out as a precaution. ' AutoRefresh End Sub.