1 Reply Latest reply on May 24, 2016 9:58 AM by Doug Womack

    Excel Refreshes - Even when PC is Turned Off? (UNC Path)

    Ankit Patel

      Based on the below method - Will the workbook still run fine if the UNC path is specified but the location of the path/Excel file PC is Turned OFF?

       

       

      A Workbook that uses a live connection to a Microsoft Excel file data source or any other file based data source, there are two ways you can update them on the server:

      Specifying full universal naming convention (UNC) Path

      1. In Tableau Desktop, select the data source from the Data menu, and select Edit Connection.
      2. In the Workbook Connection dialog box, type the full universal naming convention (UNC) path to the data source in the Step 1 text box.

      For example,  D:\datasource.xls has a UNC path that looks like the following:

      \\workstation1\d$\datasource.xls, where "workstation1" is the full computer name.

      1. Select Server > Publish Workbook.
      2. In the Publish Workbook to Tableau Server dialog box, remove the selection from the Include External Files check box.
      3. Click the Publish button.

      A Workbook that uses a live connection to a Microsoft Excel file data source or any other file based data source, there are two ways you can update them on the server:

      Specifying full universal naming convention (UNC) Path

      1. In Tableau Desktop, select the data source from the Data menu, and select Edit Connection.
      2. In the Workbook Connection dialog box, type the full universal naming convention (UNC) path to the data source in the Step 1 text box.

      For example,  D:\datasource.xls has a UNC path that looks like the following:

      \\workstation1\d$\datasource.xls, where "workstation1" is the full computer name.

      1. Select Server > Publish Workbook.
      2. In the Publish Workbook to Tableau Server dialog box, remove the selection from the Include External Files check box.
      3. Click the Publish button.