1 Reply Latest reply on Jul 23, 2018 4:09 PM by Hari Ankem

    Refresh clipboard data?

    Shikhar Gupta

      Hi Tableau Users and Experts,

       

      I am hoping to get some clarity about how clipboard works. I am building a dashboard where data comes from multiple excel sheets. I have a worksheet (say A) where i bring in data needed from these excel sheets (like a vlookup but with more calculations). My next steps involve building a pivot from worksheet A. I was able to copy data from worksheet A on clipboard and use that as data souce and build the pivot i needed. This was much quicker and avoided potential complex logic to count these records. My question here now is that i am trying to have the clipboard data refresh everytime worksheet A is refreshed with new data.

      Is there a way to have the clipboard data refresh or link to the worksheet it is copied from?

       

      Any help will be much appreciated. Thank you

       

      Regards,

      Shikhar