Excel 2007 crashes after refreshing data linked to external source



Multiple users have reported a reproducible issue when using Excel 2007 with
pivot data that are linked externally to a database.

The steps to reproduce the issue are following:
1. Open the excel file and ran refresh.
2. Close the excel documents
3. When prompted to save the file, “No†is clicked
4. Open the same file again without closing excel. Error notification window


Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the inconvenience

Event log details:

Event ID: 1000
Source: Microsoft Office 12
Description: Faulting application excel.exe, version 12.0.6425.1000, stamp
49d64dd6, faulting module exel.exe, version 12.0.6425.1000, stamp 49d64dd6,
debug? 0, fault address 0x002fdf83

Office versions affected: MS Office Professional Plus 2007 SP1 and SP2

Steps performed:
-Added My Documents in trusted zone
-Enabled all Data Connections and Automatic update for all Workbook Links
-File in 2007 format

Trust Center Settings

Macro : Enabled All Macros
Data Connections: Enabled data connections
Workbook links: Enabled automatic update for all workbook links

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question