• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3301
  • Last Modified:

Blue Screen when using a Pivot table in Microsoft Excel

I get a Blue Screen when ever I want to use a pivot table in Microsoft Excel 2007. The stop code I have been getting is 0x0000008E and it also had a file name which is dqvddrv.dll. The laptop is a IBM Thinkpad. It only happens on a certain file and only at a certain spot.
0
transystems
Asked:
transystems
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Sounds like a corrupted workbook or a corrupt Excel installation. You can try repairing the workbook but I suspect a bad Excel installation.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
There are many possible causes for corrupted workbooks. The most common are problems with the internal tables used to store cell formatting information and corrupted p-code. It is usually very difficult to determine the cause. Below are some techniques for repairing a corrupt workbook.

If access to Excel 2007 or later is an option then open the workbook using 2007 or later, export the VBA code to files, save the workbook as XML, re-import the VBA, and save the workbook in the desired format.

If the problem appears to be with the VBA code then a free utility called CodeCleaner is a good resource to have (http://www.appspro.com/Utilities/CodeCleaner.htm).

An easier overall solution is to use a commercial third party tool such as Excel Workbook Rebuilder from VBUsers.com (http://www.vbusers.com/commercial/Rebuild.asp).

Kevin
0
 
transystemsAuthor Commented:
Reparing Microsoft office 2007 worked out.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now