7 Replies Latest reply on Sep 26, 2013 6:58 AM by preeti.prajapati

    Migrate dashboard tab from one workbook to another

    subra.m.1

      One of my workbook contains over 10 tabs with multiple data connections. Each dashboard tab contains multiple worksheets. Due to various business reasons, I had to copy workbook with 2 different names and make changes to different tabs in each workbook. Now I have to combine both versions into one master.

       

      I know that if it was individual worksheet(s), I could use bookmark process. But here, I need to bring in the whole dashboard tab (containing over 10 sheets) from one workbook into another. It will be very painful to bring each sheet and create dashboard manually. With this setup (i.e. 2 workbooks), is there any automagical way to merge the changes from one workbook into another ?