Any chance you could attach the workbook and the Excel sheet?
Are you using the Extract or Live?
If Extract then just drag new sheet as new data source and replace.
"[TableauTemp].['Sheet 2$']" <<<<<< I Don't think this is Excel Error
1 of 1 people found this helpful
Find my approach below,
Just assume you've SALES data and initially name of the sheet was "Sales".
Now you've renamed the sheet as "Category Sales" and saved the excel workbook and the moment you wants to refresh the source.
Just go to data source and edit the connection and re point the excel file again. You can see the updated sheet in list though old sheet name will be invalid.
Now just drag the latest sheet on top of old sheet.
Now it'll be valid and updated.
Let us know if this help.
Could i do that and then go back to Live?
Yes You Can
that is what i did, bit i keep getting the error when i drag the renamed sheet over the old one. For now, i just changed the names back and it started working again.
Another technique to remedy this situation is to sideload your data again (Data > New Data Source), then replace the original data source (Data > Replace Data Source). Even if you are writing over the top with the same data this refreshes the connections.