7 Replies Latest reply on Jul 30, 2013 12:57 AM by feds akino

    Copy Workbook and Raw Data To New Location

    Louis Keating

      Hey guys,

       

      I've been looking into replacing data sources and am wondering if there is a work around.

       

      I've created a dashboard to analyse Facebook data. The purpose is to be able to drop in new data into the same dashboard and have it automatically update.  The Facebook data comes as an .xlsx file. What I could do is copy paste the new data into the same Excel file. This would ensure all the calculated fields and variable types don't change. Just the raw data is changing. The problem with this is, my original data will be overwritten.

       

      How can I duplicate both the workbook/dashboard, and the raw data, and copy everything to a new location?

       

      I've tried pointing the workbook at a different file but then it loses all the calculated fields and variable types.

       

      Is my question above possible?

       

      Thanks!