Goldcar400
New Member
I am using an Excel Real Time Function, =RTD(), which will constantly update when another program is active at the same time. RTD will not work without the other program.
I want to grab the end of the day data for storage but the =RTD() function is constantly updating.
2 Questions
1. Without using VBA, how to sample data from using =RTD() function one time and permanently save one time sample in same or another cell without it being overwritten? The Real Time Data function is constantly updating.
2. After 1 time sampled data has been stored in a cell, upon opening spreadsheet even though RTD function is not connected (the other program is not active), the previously captured data can sometimes disappear because it is waiting for an update. How do I prevent the data from disappearing when I open the spreadsheet? Or how to permanently store previously captured data?
Regards
Tony
I want to grab the end of the day data for storage but the =RTD() function is constantly updating.
2 Questions
1. Without using VBA, how to sample data from using =RTD() function one time and permanently save one time sample in same or another cell without it being overwritten? The Real Time Data function is constantly updating.
2. After 1 time sampled data has been stored in a cell, upon opening spreadsheet even though RTD function is not connected (the other program is not active), the previously captured data can sometimes disappear because it is waiting for an update. How do I prevent the data from disappearing when I open the spreadsheet? Or how to permanently store previously captured data?
Regards
Tony