IssueWhen opening a workbook where the data source has tables joined using a pivot field, the following error might occur:
There was a problem connecting to the data source '<data source name>'.
Would you like to edit the connection information ?
Field '[Pivot].[Pivot field names]', which is included in a join clause, does not exist.
Unable to connect to the file "". Check that the file exists and that you have sufficient access privileges for it.