Excel crash when refresh pivot table

[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

 

[Jerry]

Found the root cause, excel will lose the parameter when saving.