Office Excel

From Indie IT Wiki
Jump to: navigation, search

Compatibility Mode

http://smallbusiness.chron.com/compatibility-mode-microsoft-excel-76192.html

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.