Real Time Data Updating?

How would I create a system where an excel file is updated in real time with new values? I have a program which logs data, and I want to have excel open, plotting the data in real time. Is this possible?

thanks alot. these all seem to be updating from the web though.

what i have is a file which updates itself in real time ( i use data logging software and it updates an excel file every few seconds). what I want is a way to "refresh" the excel file every few seconds to have the new values

ok, is there any way that the file can be automatically copy-pasted elsewhere, then loaded in excel? then when i want to update or "refresh" the file, it automatically copy and pastes it again, then re-opens the excel file? right now i am doing this manually (copy-pasting), but i want to know if there is automated way to do it.

I don't understand...

what i have is a file which updates itself in real time ( i use data logging software and it updates an excel file every few seconds). what I want is a way to "refresh" the excel file every few seconds to have the new values

You have a third party application that sends data to an Excel file?
This happens every few seconds?
What do you need to refresh?

You can, through various methods, automatically run code when these updates occur.

It sounds as if you you want to chart the incoming data as it is recieved. Correct?

yes that is correct, i want a chart to automatically update. and i do have a third party application which updates an excel file every few seconds

Papermoon. Provide some details please such as what ranges are being updated. Are there DDE links in these range? RDT functions? Is the data send directly to Excel from the third party app? I cannot help you without some details as there are various methods for responding to dynamic updates.

Hey there is this new JSON Data site that is in beta that should help you out. It is free and updates real time. Hope this helps.