Excel open Blank instance of exel.

Rahi Padariya 96 Reputation points
2021-07-12T13:49:39.623+00:00

Hi,
One excel blank window open while we open file from Local PC drive or from file server or using link of file server file in outlook.
but if we open SharePoint file directly or from link in outlook mail, blank excel window not come.
we are using macro, so we put one excel macro file in XLSTART folder in Program files\Office\XLSTART folder and hide the file . which run every time as we start excel.

so kindly guide how to avoid blank excel window while we open local PC drive excel file or from File server opened excel file

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-07-13T05:48:16.26+00:00

    @Rahi Padariya

    Could you please share us which version of Office are you using now?

    Will the local workbooks opended as blank if you open them in Excel app?
    I suggest you temporarily move the macro file and other startup items from Startup folder (Such as Microsoft Office Professional Plus 2016, C:\Program Files\Microsoft Office\Office16\XLStart , C:\Users\<User Name>\AppData\Roaming\Microsoft\Excel\XLSTART ) and disable Excel COM add-ins to check this issue.

    Please also go to File > Options > Advanced, under General part, ensure "Ignore Other Applications that use Dynamic Data Exchange (DDE)" is unticked.

    Any updates, you may post back.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Rahi Padariya 96 Reputation points
    2021-07-15T09:26:25.923+00:00

    hi,
    but macro start with excel is my requirement. Also i check this issue not come in office 2010.

    this issue is resolve if i remove my macro file from XLSTART folder but i need macro file.

    any other solution available.

  3. Stacy Clark 21 Reputation points
    2021-07-21T06:40:36.737+00:00

    I will suggest following these steps:

    1. Open the MS Excel program on your system (Not the Excel file). Double click on the MS Excel Icon.
    2. Click o File, go to Options
    3. Under Options, you will have to go to Advanced.
    4. Go to the General section
    5. Uncheck "Ignore other applications that use Dynamic Data Exchange (DDE)"
    6. Click on OK and close the Excel

    Try this and let me know.

    Good Luck!
    Stacy