Forum Discussion
How to refresh excel data and remove previous data automatically
I have to update a reporting template based on an excel sheet. How could I update excel sheets automatically and remove previous data? I can upend data by using Power Query refresh. I do not want tha...
You can still do that by power query. Power query can configure to auto refresh in every n minutes where n can 5, 10, 30 or any number. You can also use FILTER() function. Better, share a sample file and show your desired outcome. Attach the file or share via OneDrive, Google-Drive, Dropbox or similar service.