This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am outputting a dataset to excel organised by teams within our organisation. This data then forms the basis of the team dashboards. The data is lists of exceptions that we need people to and deal with and clear.
I have experienced an issue where the data from yesterday has been cleared. I would therefor expect that the output would overwrite yesterday's data to show no outstanding data for that team. It seems that when there was brought forward data which then there is none, the output doesn't clear the brought forward data.
Has anyone else experienced this?
I have copied the settings from my output. Is there an obvious setting that I haven't configured correctly?
I managed to work around by setting up a template output file with all of the possible outputs predefined as tabs in the file. Not as elegant as your solution but got me to where I needed to go. Think I will take your approach though going forward!
I'm working on .xls file, when I try to overwrite sheet its not working. I believe it was something with the Excel format and its working file for .xlsx. But I need to export the data into .xls as we need to format the data sheet.
Do you know whether we have any other option where we can overwrite the existing file in .xls ?