I'm importing live data into Excel which is changing constantly. How can I record the data so that when it changes I have the previous value saved?

Also I want to change the frequency at which the data refreshes. Under "Connection Properties" it only allows for a minimum of 1 minute. As my data is changing constantly is it possible to shorten this frequency (say to 1 second)?

Welcome to the Forum,

Sorry that no one has replied to you as yet. How have you been getting on with your question?

Do you have code already created for the refresh if so if you copy it into your thread I will take a look and add some kind of loop so it copies values to a history sheet so you can keep the previous values.

You can refresh your connects to less than 1 minute intervals. You would need to look up the OnTime process in the VBA help and you will get something like this

Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"