Office Excel
Error Logs
Microsoft Office does not create log files, but keeps all events in Windows event logs system instead.
If the version of Microsoft Office you are using is 2010 or 2013, you should do the following steps:
- In Control Panel, open Administrative Tools.
- Start Event Viewer.
- In the list of event logs, select Application.
- Choose Microsoft > Office Logs.
- On the View menu, click Filter.
- In the Event source list, select VSTO 4.0.
- For installation events, in the Event ID box, type 4096.
- Click OK to see the filtered view.
If you are using Microsoft Office 2007, you can also find MS Office journals in Windows event logs. Not in Application log, but in two separate log categories: Microsoft Office Diagnostics and Microsoft Office Sessions.
Compatibility Mode
http://smallbusiness.chron.com/compatibility-mode-microsoft-excel-76192.html
Suggestions Website
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
HOWTO: FIX:
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.
Method 1:
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.
Method 2:
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.
For instance:
C:\Users\[user.name]\AppData\Local\Temp\Excel8.0\MSForms.exd
C:\Users\[user.name]\AppData\Local\Temp\VBE\MSForms.exd
C:\Users\[user.name]\AppData\Local\Temp\Word8.0\MSForms.exd
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.
http://www.excelforum.com/excel-general/741490-excel-2008-find-merged-cells-mac.html
Windows fix.
