Excel crash when refresh pivot table

J

Jerry

hi, i use a pivot table in excel, it receives data from microsoft query, the
sql likes "select * from tableName where time = ?", the parameter is
contained in a cell other sheet. When i changed parameter value, and clicked
refresh button, the excel crashed.

Error:
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-12-11T02:52:21.000Z" />
<EventRecordID>65615</EventRecordID>
<Channel>Application</Channel>
<Computer>forfoman1.fareast.corp.microsoft.com</Computer>
<Security />
</System>
- <EventData>
<Data>EXCEL.EXE</Data>
<Data>12.0.6514.5000</Data>
<Data>4a89db07</Data>
<Data>EXCEL.EXE</Data>
<Data>12.0.6514.5000</Data>
<Data>4a89db07</Data>
<Data>c0000005</Data>
<Data>00b8456b</Data>
<Data>c7c</Data>
<Data>01ca7a0ce6d424f4</Data>
</EventData>
</Event>

Any suggestion is welcome, thanks!

Jerry
 

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

Top