Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Create and access a list of your products
Sign In Create an Account Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

How to stop Excel 2016 crashing on a Touchscreen computer with Windows 10 when you use Visual Basic functions

Summary: The following article provides information about a specific issue. It occurs when you clear the filters within the Microsoft Office 2016 Excel application on a touch screen computer running Windows 10. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Table of Contents:

  1. Introduction
  2. Description of the fault condition
  3. How to resolve the issue
  4. Further Information

Introduction

 

This guide describes how the fault presents itself and how you can identify it. It takes you through Microsoft's solution for the issue. It also provides some further information from Microsoft sources about the issue.

Cause

Description of the fault condition

 

It has been reported that the Microsoft Office Excel 2016 32 or 64-bit applications crash whenever they attempt to open or work with their files.

The issue happens when you are opening a large file and start using the AutoFilter function. Clearing filters causes Excel to stop responding.

This issue is seen when you are running Microsoft Office 2016 and Windows 10 on a computer that is configured to use a touch screen LCD.

A temporary workaround was to disable the touch screen driver from within the device manager. This solves the issue and allows you to work on Excel without any issues, but takes away the touch screen input.

NOTE: This is because the function that runs a Visual Basic (VB) program interacts with the same memory range as that used by the touch screen driver.

There are other issues that can cause Excel 2016 to crash. This guide only deals with those that have the following factors:

  • Windows 10
  • A computer with a Touchscreen is configured
  • Microsoft Office 2016
  • VB programs running within applications

Resolution

How to resolve the issue

 

Microsoft's current advice is to update your revision of Microsoft Office 2016 with the two Microsoft fixes listed below:

NOTE: These fixes are not available through the Microsoft Update process, but only from the Microsoft Website.

Additional Information

 

You can find out more about the issue on Microsoft's Community page, or on the Excel Support page. I have included some links below that deal with this issue on both sites.

NOTE: Since December 16, 2016, Dell no longer ships an Office product key card to activate your product if you purchased your Microsoft Office product with your Dell computer. This excludes computers sold in Japan and computers sold with a Windows 10 downgrade to Windows 7.
Office
Install, activate, or troubleshoot Microsoft Office software coming with your Dell device or bought as a stand-alone license by visiting our Office Support site.

Affected Products

Inspiron, Latitude, Vostro, XPS, Fixed Workstations
Article Properties
Article Number: 000137129
Article Type: Solution
Last Modified: 13 Mar 2024
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.