Office Excel

From Indie IT Wiki

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

https://excel.uservoice.com/

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.