every time I switch data recourse the columns/rows on become red and graphics are showing. i attached the views. First view is on data I refresh and choose the sheet that I need to refresh, but the columns/rows are red and no graphics that was created.

Please read the concepts on Replace Data Sources - Tableau and from there if you have specific fields that are showing with a red exclamation point, you need to address those with Edit Data Sources for      Replace Field References to resolve those.

Best, Don

(Please, don't forget to click Select as Best or Upvote !)