I created a dashboard a little over a year ago with multiple related data sources from Excel spreadsheets. Some of the spreadsheets have been updated with new annual reporting data (the others are structural, containing data needed to plot some of the charts, and do not need to be updated) and I am trying to connect them to the dashboard. Under Data, only 2 of sources appear, though there were more when I set it up:When I try to Edit Data Source for ASES 2022:23-2023:24 Survey ALL and select the file, the file browser window just pops again. When I try to refresh and select the file, I get this:
Which is a file I don't have. When I view the data for ASES 2022:23-2023:24 Survey ALL, I get this:
Which shows a number of the other data sources, but not Donut.xlsx
I don't know what's going on. Is it because these sources were all related? Have the relationships been corrupted?
I don't want to have to rebuild this dashboard from scratch. It's pretty complicated, and honestly, I don't even remember how I did it :(
Any help greatly appreciated!
I'm using Desktop Public version 2025.2.0 on Mac with Apple Silicon.
Attaching the workbook.
#Tableau Public #Tableau Desktop & Web Authoring
You can try to edit the .twb file, which is basically an xml file, and modify any connections (file locations) manually.
In order to get to it, the .twbx file is a zipped up folder with the .twb file and the data. Open it using 7-zip or some other program, unzip, and you'll see the .twb file, then open that with Notepad++ (or similar).
I looked at your file and there are two data sources there, with several connections. Modifying them to point at the correct files may solve the problem. Here's a sample connection string from your file (row 66):
<connection class='excel-direct' cleaning='no' compat='no' dataRefreshTime='' filename='/Users/bigkid/Desktop/ASES 2022:23-2023:24 Survey ALL.xlsx' interpretationMode='0' server='' validate='no' workgroup-auth-mode='as-is' />
After modifying, just open the .twb file again in Tableau Desktop.
Dan ChissickSenior BI Consultant | Tableau Ambassador
