Monday 16 May 2016

Delay in Opening Word, Excel Files

Hi everybody!!!

Today i am giving an interesting tip for computer users in an Office/ House/ Shops etc....

Delay in Word, Excel File Opening..

Problem:- If I double-click on a word or excel document on the desktop, or try to open a Word attachment from an email, it takes about a minute.

Reason

The DDE function appears to be corrupt. To work around it I did the following:

Solutions
Go to Control Panel, Folder Options, File Types, scroll down to and select (XLS, XLSx, DOC or DOCx), click Advanced, select Open, click the Edit button. Now uncheck "Use DDE" and then put your cursor on the Application box, arrow all the way to the right and put in "%1" (include the quote marks), If there is a /dde remove it. Then OK your way out. Things should work quickly again.


Now You can easily open your files without waiting......!!!!

4 comments:

  1. Kindly explain, how we can insert Rs. in the excel sheet's column.

    Eg. Rs. 10

    ReplyDelete
  2. Hi, Sumesh ....Thanks for writing to me....

    Solution for You is posted in the link https://solutionsforwhyhow.blogspot.in/2016/05/delay-in-open-word-excel-files.html#comment-form

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete

COUNTIF FUNCTION FOR FILTERABLE DATA

Summary:- While using COUNTIF function of Excel, the count if function will not work for filterable data as the values will not change as pe...