I recently had to re organize how we keep our data for tableau usage, we have tableau connected to an excel file within a sharepoint site. I changed the title of the SharePoint folder in which tableau connects to so my workbook is now giving me the error "Worksheet Unavailable - There was a problem connecting to the "file name" data source."
Does anyone know how to fix this? Or if I reconnect it to the file under a new folder name if it will be able to properly connect the data to the worksheets since the data file will have all of the same information and fields?
Thank you in advance!
I would reconnect to the new file and replace old connection with new, if Column Headers are not Changed, Even if column Heders have changed , it is easy to Replace References.