I have spreadsheet that gets open daily with Task Scheduler and than I add Macro to Update Only $A2 to =TODAY()-1 and the rest of the rows below will update based on: =$A2 and my data will update based of the date field. I added the file to Server but only date is getting update the data is not refreshing. Should there be any code that will wait until the data gets refreshed anything like that?? So can someone help me with this. Thanks in Advance.