I believe I have tried everything; checking Tableau site for instruction, adding a data source, refreshing data source. When I add a new table and tab to my Excel source file, I cannot get them to show up in Tableau workbook. I only see the tables from the original loading of my Excel workbook. When I go to 'add a source', it only brings up the source workbook again, not individual tables. After I select the same workbook again and refresh the connection, no new Excel tables appear. I don't think I need to create a new Excel workbook every time I add data, or, do I? Thank you!
P.S. Sometimes a new table will be added as a data source, however when I drag the table into the data source area, I get this message. Sometimes, it causes a crash and I lose my entire workbook.
Unable to complete action
Bad Connection: Tableau could not connect to the data source.
Error Code: 81B3934F
An error occurred while communicating with data source 'Sales!Sales_Table (Electric Cars)'
