Enabled Preview in Windows Explorer causing issues with Excel and Excel add-ins

During the process of testing and preparing the new version of our top Excel product to release, we have found some cracks in the latest updates of Office 365 that affect our add-ins as well as all the Office applications even if the Ablebits program is not installed in the system. In this article we'd like to clarify what causes the problem, how it can show itself in Excel 2016 and suggest a simple workaround.

We know how useful the Preview feature in File Explorer can be for the Windows users as well as how much the Ablebits users rely on our add-ins in their work. Both are practical in use and are developed to boost productivity while working with Microsoft Office (Word, Excel, etc.) files. Thus, it is an extreme nuisance when you can't get Windows Explorer, Preview, Office, and Ablebits work together without issues.

Symptoms: how to identify the problem in Excel

Firstly, we want to mention the glitches that might be seen in Excel with regard to our add-ins. Sometimes after Excel starts, the Ablebits icons turn to be inactive and some interface defects are observed in the application:
alt=Ablebits add-ins can be disabled after Excel starts

If the add-ins are active and you can run them, you may notice that the add-in box is blank like the one in the picture below:
alt=Add-ins' dialog windows can be displayed incorrectly

Or you have no options to select like on step 2 of our Merge Tables Wizard:
alt=The open workbooks are not displayed in the add-in window

Though the problem appears to have mostly the visual affect, it makes our tools out of work.

If we stand back from the Ablebits add-ins, you can see the unusual behavior in Excel itself. The program starts taking more of the system resources than usual. The size of the Excel windows as well as fonts and different interface elements can change randomly. At times Excel freezes and remains to hang in the Processes even after all Excel windows are closed. The other open Office applications (Outlook, Word, PowerPoint, etc.) may not respond for some period of time.

Cause: what leads to the issue

After some investigation we've found out that the problem occurs when the Preview pane in Windows Explorer is open.
alt=Enabled Preview pane in File Explorer causes the issue

We've also detected that besides the visual affect this Microsoft bug can break down the functionality of the Office object model. For example, the simple VBA code stops working after previewing an Excel file in Windows Explorer. You can follow the steps below to reproduce the issue:

  1. Open a blank workbook in your Excel.
  2. Then open Windows Explorer and turn the Preview pane on under the View tab:
    alt=How to enable the Preview pane in Windows Explorer
  3. Select any workbook in File Explorer and switch back to Excel.
  4. Press Alt + F11 to open Visual Basic Editor.
  5. Right-click on your workbook name in the Project-VBAProject pane at the top left field of the editor window and select Insert -> Module from the context menu:
    alt=How to insert a macro in the VBA editor
  6. Copy this VBA code and paste it to the top right field of the VBA editor:
    		Sub TestPreviewIssue()
    			Debug.Print ActiveWorkbook.Windows.Count
    		End Sub
  7. Press F5 to run the macro and you'll see the following error:
    alt=A simple macro doesn't work when the Preview pane is on

If you close Windows Explorer and run the macro again, the code will have worked successfully, and the result will be shown in the bottom right field of the VBA editor:
alt=You'll see the result if the macro works fine

Treatment: how to solve the problem

Disabling the Preview pane makes the problem stop happening. You can change your File Explorer View settings by performing the following steps:

  1. Open File Explorer and move to the View tab.
  2. Select "Preview pane" to remove it from being highlighted:
    alt=How to turn the Preview pane off
  3. Close File Explorer and check if the issue occurs.

We do hope that Microsoft will fix the problem with the Preview pane in Windows Explorer soon. However, until the next Office update comes out, we highly recommend turning off the Preview mode in File Explorer or at least avoiding it when you work with the Ablebits add-ins in Excel or with the other Office programs.

Thank you and sorry for any inconvenience

If you have any questions or concerns, please feel free to leave them in comments to this post or reach out to our support team at support@ablebits.com. We thank you for your understanding!

12 responses to "Enabled Preview in Windows Explorer causing issues with Excel and Excel add-ins"

  1. Vojtěch Dohnal says:

    Indeed, I was able to reproduce the error. It happens when explorer windows is open after Excel exactly as you wrote (but not the other way round). Shame Microsoft connect does not support bugs for Excel to upvote.

  2. Alex says:

    Привет, ребята :)

    Тоже столкнулся с ошибкой при использовании предпросмотра. Написал макрос для Excel, обрабатывающий документы Word. Макрос выводит диалог выбора документов (FileDialog), а потом обрабатывает выбранное. Если в FileDialog включить предпросмотр (он работает), то дальше, при работе с Word, макрос вылетает с ошибками: либо "Automation error", либо "The remote server machine does not exist or is unvailable". Вся работа идет локально, с самыми банальными документами.

    При включении предпросмотра - ошибка есть, при выключении - нет. Ошибка пропадает, при наличии какой-то паузы после FileDialog. Например, если вставить MsgBox или если поставить точку останова в коде.

    Как оказалось, ошибка появляется при наличии любой (наверное, перепробовал кучу разных) надстройки в папке Startup программы Word. Нет надстроек - нет ошибки.

    C уважением, Александр.

  3. Ben says:

    Issue persists as of 2/4/2019. Disabling the preview pane is not a solution.

  4. Jiří Kolář says:

    Should i switch back to Windows 7 where it worked?

  5. Kyle Odom says:

    I found your article via a web search. In my case I had the details pane enabled in Windows Explorer and not the preview pane and was having the same issues. Disabling the details pane corrected the issue for me. Thank you so much, you saved me a lot of frustration!

  6. Shawna R Snyder says:

    I second Kyle, disabling the Details pane in the View tab of File Explorer fixed the problem. Thanks for sharing!

  7. Paola Venegas says:

    Same here. Just go tothe View pane in Windows Explorer, enable "details pane" , wait intil the image on the righ appears, go back and now enable "preview pane" and you will see a preview for all files, includind word and power point.

  8. Hussain Valiuddin says:

    Is there a solution to the problem besides turning off preview pane? The solution seems to have worked but it is inconvenient to not use preview pane.

  9. Kashif Riaz says:

    Good face good Work - Thank you Ekaterina

Post a comment

Thank you for your comment! When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to your query. We cannot guarantee that we will answer every question, but we'll do our best :)