3 Replies Latest reply on May 15, 2018 10:26 AM by Richard Couillard

    Tableau won't load after deleting a column in Excel source file

    Richard Couillard

      Hi. I have a live connection to an Excel sheet which loads fine. I want to delete one of the columns in the Excel sheet but when I do, Tableau crashes when loading the source data. If I replace the Column in Excel, it loads fine. How do I delete the column in the source Excel sheet so Tableau will load and pick up the change?

       

      Also on a related note, I am unable to "Save" any changes to my Excel sheet as long as the Tableau story is open and connected to the source file. I assume that is a file lock issue but am wondering if there is a setting or something I can do to allow changes to be made to the source file and be reflected in Tableau without having to close and restart Tableau.

       

      Thanks