We have PI DATALINK function which generates data in every min. However, I get this message in the last cell ( resize to show all values) . I do the resizing manually by clicking apply and ok in the function window. I believe there is a solution using VBA to overcome this challenge but couldn't obtain it. Could you help solving this issue ?.