Excel crash when refresh pivot table

  • Thread starter Thread starter Jerry
  • Start date Start date
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
 
I am receiving error with Excel 2003 where I am trying to go into Pivot Table Wizard to re define the source... it crashes killing Excel and restarts. I have closed everything and reopened document to have same issue. any ideas?
 
I have the same problem - access the pivot table wizard to re-define source and Excel crashes. I use Excel 2003. Any help is much appreciated.
 
I have the same problem. Now I am trying to connect to the access DB (2010) from a blank spreadsheet. As soon as I indicate the location of the DB, Excel crashes. Any help would be appreciated.

Tomas
 
Back
Top