1 Reply Latest reply on Aug 15, 2013 7:47 AM by Joshua Milligan

    Replace data source on a single worksheet

    Amanda Blondeau

      Is there a way to replace a data source (same structure) on only a single worksheet and not all in the workbook?

        • 1. Re: Replace data source on a single worksheet
          Joshua Milligan

          Amanda,

           

          One thing you might try is creating a bookmark (while on the sheet you want to change, from the menu select "Window" --> "Bookmark" --> "Create").  Save the bookmark file.  Then open the bookmark file you just saved (select "Window" --> "Bookmark" --> "Name of Bookmark Just Saved").  Rename the new data source and you'll have a new data source that matches the old one, but is just for that sheet.

           

          Regards,

          Joshua

           

          Data Source.PNG.png