Link to old File

AllisterB · October 28, 2020, 8:17am

I have a workbook with about 25 Power Queries. When I do a Refresh All I get this message
*We couldn’t get the data from Table46in the workbook s:\Expenses.xlsm. Open this workbook in Excel and try again.

I have used the add-in FindLinks - but this could not find when the file was referenced.

How d do I quickly find which Querty references the file?

Kind Regards

Allister

AntrikshSharma · October 28, 2020, 8:30am

maybe from query dependencies option?

AllisterB · October 28, 2020, 9:12am

Thanks for the idea - I did this and the file is not mentioned. Could it be referenced some other way other than a PQ? As I said I have used Find Link and this did not locate any reference to the file.

Does anyone else have any ideas ?

Thanks