G
Gan
I have create a Pivot table in excel 2007 using the microsoft query in data
source and link to MS SQL 2005. I have try using the SQL server and SQL
native client to built the connection string to connect to the SQL server
located in my pc.
I have done all the setting and able to query the data from the SQL Server
and manipulate the data in pivot table in excel 2007.
the problem i facing now is after i have save the excel file in my pc. the
next time i open up the excel file and press the refresh button, it prompt up
to ask me fill in the SQL server database. after that the excel file corupted
and automatic close by Vista.
I have try many methos and search online for similar case, but so far i
still unable to find related information regarding to my problem now.
Please refer to the details that i get from the event viewer.
Log Name: Application
Source: Application Error
Date: 18/02/2009 11:40:10 AM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: fygan
Description:
Faulting application EXCEL.EXE, version 12.0.6331.5000, time stamp
0x48fa2869, faulting module EXCEL.EXE, version 12.0.6331.5000, time stamp
0x48fa2869, exception code 0xc0000005, fault offset 0x00b709f9, process id
0x1820, application start time 0x01c991792340ee50.
Event Xml:
<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-02-18T03:40:10.000Z" />
<EventRecordID>119603</EventRecordID>
<Channel>Application</Channel>
<Computer>fygan</Computer>
<Security />
</System>
<EventData>
<Data>EXCEL.EXE</Data>
<Data>12.0.6331.5000</Data>
<Data>48fa2869</Data>
<Data>EXCEL.EXE</Data>
<Data>12.0.6331.5000</Data>
<Data>48fa2869</Data>
<Data>c0000005</Data>
<Data>00b709f9</Data>
<Data>1820</Data>
<Data>01c991792340ee50</Data>
</EventData>
</Event>
Please help me to figure out where goes wrong with my step?
Thanks a lot.
source and link to MS SQL 2005. I have try using the SQL server and SQL
native client to built the connection string to connect to the SQL server
located in my pc.
I have done all the setting and able to query the data from the SQL Server
and manipulate the data in pivot table in excel 2007.
the problem i facing now is after i have save the excel file in my pc. the
next time i open up the excel file and press the refresh button, it prompt up
to ask me fill in the SQL server database. after that the excel file corupted
and automatic close by Vista.
I have try many methos and search online for similar case, but so far i
still unable to find related information regarding to my problem now.
Please refer to the details that i get from the event viewer.
Log Name: Application
Source: Application Error
Date: 18/02/2009 11:40:10 AM
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: Classic
User: N/A
Computer: fygan
Description:
Faulting application EXCEL.EXE, version 12.0.6331.5000, time stamp
0x48fa2869, faulting module EXCEL.EXE, version 12.0.6331.5000, time stamp
0x48fa2869, exception code 0xc0000005, fault offset 0x00b709f9, process id
0x1820, application start time 0x01c991792340ee50.
Event Xml:
<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-02-18T03:40:10.000Z" />
<EventRecordID>119603</EventRecordID>
<Channel>Application</Channel>
<Computer>fygan</Computer>
<Security />
</System>
<EventData>
<Data>EXCEL.EXE</Data>
<Data>12.0.6331.5000</Data>
<Data>48fa2869</Data>
<Data>EXCEL.EXE</Data>
<Data>12.0.6331.5000</Data>
<Data>48fa2869</Data>
<Data>c0000005</Data>
<Data>00b709f9</Data>
<Data>1820</Data>
<Data>01c991792340ee50</Data>
</EventData>
</Event>
Please help me to figure out where goes wrong with my step?
Thanks a lot.