I am connected live to a few excel 2010 sheets. One in particular displays the message "an error occurred while communicating with data source 'file name.xlsx''. I have tried refreshing data, closing both tableau and the file and reopening. There is a solid pink line on the left hand side of this data in both Dimensions and Measures. What is causing this issue?
I have had similar issues, I found that mine was due to custom macros / filters that were giving grief. If I opened it in Excel and did a save as 2003 format it was able to import.