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.
In order to colour code the outputs of my 4 data streams, I had to use Render tool.
Currently, once the 4 streams of data are cleaned/filtered/labelled, each data stream is output into separate worksheets. Then, these worksheets are referenced in a 'Summary' worktab that is contained in the same excel file.
Once I hit 'refresh data' in the 'Summary' worktab, the pivots/graphs refresh as well.
However, with the introduction of Render tool, the output file completely replaces the existing excel file. This means the Summary worktab is gone & I am unable to carry forward the pivoting logic.
Is there a way to output render tool to 'replace existing sheet/drop data in existing sheet', similar to when you're outputting directly to Excel file?
One of the ways I can think of going about this Render Outputting is to:
1. Render Output to a temporary excel file
2. Somehow combine the tabs of the temporary excel file & the worksheet containing pivot logic into a new excel file.
Not sure if you will be able to overwrite an existing sheet, but you should be able to create a new sheet and use that moving forward. You will just have to copy over your charts and formulas initially but it will be good to go afterwards.