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 running a query that outputs to excel, splitting by a column, and appending the date to the end of the file. I figured out how to separate the sheets and add the date to the sheet here. It saves to the network location correctly, and I am able to open it from there, but when I open it from the email, I get the error messages in picture 1 & 2.
Does anyone know what I am doing wrong? @MarqueeCrew you helped me previously and in another thread I was reading, or @JosephSerpis from helping get me this far with the excel naming!
Hi @zacharypappas can you change the Output Option from Create New Sheet to Overwrite Sheet (Drop) and see if that returns the same error? Could you also consider changing the file to a .csv to see if you have the same issue as well please?
@JosephSerpisI tried changing it to Overwrite Sheet (Drop) and it resulted in the same issue. I previously had it as a CSV, and it worked fine, but was requested to be spit by a column in the data (sales rep), and CSV's do not support multi-sheet, or else I would do that.