i done down grade my excel to 2003, but still the data did not show. is it true that this software not compatible with windows 10 ? because currently i'm using windows 10. thanks for your advise. 
miss_Hanin:
i done down grade my excel to 2003, but still the data did not show. is it true that this software not compatible with windows 10 ? because currently i'm using windows 10. thanks for your advise.
It wouldn't surprise me that software that is restricted to Excel 2003 which is 13 years old would not work on Windows 10.
In addition, Excel 2003 is not officially certified by Microsoft to be compatible with Windows 10.
You have got a double whammy.
can you suggest any other solution beside use plx-daq ? any kind of software that can retrieve live data from arduino to excel ? thank you
Why do you need to use Excel? There are other ways to display graphs of data live from the Arduino.
PaulS:
Why do you need to use Excel? There are other ways to display graphs of data live from the Arduino.
He wants to retrieve the data and graph it.
He could always try learning VBA for Excel, but that seems to be too much of a bother for some folks.
He wants to retrieve the data and graph it.
It's serial data. IDE version 1.6.9 comes with a serial data plotter capability.
miss_Hanin:
s it true that this software not compatible with windows 10 ?
If that is true, I would have thought that Windows 10 would have advised you to that effect.
can you suggest any other solution beside use plx-daq ? any kind of software that can retrieve live data from arduino to excel ?
You might try Live Graph. I preferred PLX but I can't remember why. I believe the fundamental difference might be that Excel is a spreadsheet, while LiveGraph merely makes csv files. That difference might not be relevant to you.
I find it more convenient to use Bluetooth Graphics Terminal. This is a bit round about but suits the purpose. The live data is shown on a graph on the phone via bluetooth. It is also recorded to SD on Arduino. This can be downloaded to the phone at leisure and transferred to Excel.
I don't think the serial data plotter in the IDE merits the slightest consideration.
PaulS:
It's serial data. IDE version 1.6.9 comes with a serial data plotter capability.
Perhaps you can point him towards a tutorial for this capability especially as to how to save that plotted data.