Highlights

Tuesday, December 5, 2017

SOLVED! Very Slow Open an Excel File

You may not believe, there's one more causes to Excel taking a long time to open a file, one unlikely reason - audio card driver!! Check if you're using Realtek audio.... if so read this...

Reference:
http://www.dell.com/support/article/uk/en/ukdhs1/sln306701/slow-performance-issues-in-excel-when-opening-saved-files?lang=en

SOLVED! Cannot Open Excel File by Double Click on It

A number of users recently experienced this - when open an Excel attachment from Outlook or double click on an Excel file in Explorer, Excel starts as blank, the file is not opened.

Probably, a setting of Excel checked - "Ignore other applications that use Dynamic Data Exchange (DDE)". You can find the setting from Excel Options - Advanced - scroll down under "General". Un-check it.

Note: DDE is being exploited and there is higher security risk by leaving this setting unchecked. That may also be the reason why recently this setting is being checked by some security updates.