Updating Office for Mac
In this case 2016
- Help menu
- Check for updates
- New window opens showing the Microsoft AutoUpdate programme, double click to run
Empty Workbooks When You Know There Is Entered Data
This problem has been observed in the Office/Excel 2003 version, the repair may or may not work in other versions.
When on opening either by double clicking or opening from the ‘File’ --> ‘Open’ menu an Excel file gives you nothing but an empty screen with no workbook try the following methods of repair.
NOTE: If the first does not work try the second.
Open Excel from the ‘Start’ menu
Click on ‘Tools’ --> ‘Options’ --> ‘General’ tab
Ensure that the tick box next to ‘Ignore other applications’ is unchecked
Close Excel and try opening a file by double clicking on it.
Click ‘Start’ --> ‘Run’
Type in the box next to ‘Open’ excel /regserver
Click ‘OK’, the Windows Installer will then run
When the installer closes attempt to open a file by double clicking on it.
Unable to insert ActiveX Object
Try this: http://support.microsoft.com/kb/2793374/en-gb - Didn't work for me but try it first YMMV
Try this: http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled - This part worked for me:
From other forums, I have learned that it is due to the MS Update and that a good fix is to simply delete the file MSForms.exd from any Temp subfolder in the user's profile.
Of course the application (Excel, Word...) must be closed in order to delete this file.
"This operation requires the merged cells to be identically sized."
The error message is received when trying to sort data, and can occur on both Windows and Mac but requires slightly differet intervention due to difference between OSs.