Hello
I have a spreadsheet(which I’ll call the “Repeater”) that is open from 8am to 4pm daily and is displayed on a large monitor(it pulls data from a master sheet on the same network drive). The sheets works great when it is first opened and it imports the data as it is supposed too. However I can’t get it to update after that no matter what I try. If I make a change to the master I have to close the Repeater and open it again to get the updates….This is not practical for the purpose of this sheet. It seems the import external data feature will not work with all the formulas on the sheet. Is there a generic piece of code that I can place on the Repeater sheet that will go and pull the new inputted data off the master sheet, I can then place an an"application on time" macro in place to run it every five minutes or so. Thanks in advance.