3 Replies Latest reply on Feb 6, 2013 5:59 PM by Dimitri.B

    If you edit or refresh the data connections of one sheet in a workbook, does it edit all of the sheets in that workbook?

    Scott Buckley

      I have a very large workbook with multiple advanced dashboards that someone in my company built. My task is to update it with new data for a different client. If I update the connection in one of the sheets will it update all of the sheets? Or do I need to do them one by one.

       

      Also, if I keep the data all in the same exact format, will all of the different dashboards just automatically update with the new data? Or will I have to recreate all of them?

       

      Thanks!!!