Workbook links and csv files

Copper Contributor

We have an Excel document which uses Workbook links to pull down data into the document.  Since the new year we  have had an error stating We couldn't get updated values from a linked workbook.  When I go into manage workbook links it only targets the csv files.  The error says the linked workbook couldn't be read.  This link exists in a name.  I know it's not a pathing issue as all the proper drives are mapped and if you actually open the csv file and refresh all the data will refresh.

 

I'm wondering if anyone else has experienced this since the first of the year, and what it could possibly be.

 

1 Reply

"When I go into manage workbook links it only targets the csv files. "  Are you sure Excel can link CSVs? My Excel does not offer .csv as a valid file extension when trying Change Source/Browse on a link.  I only ever import values from CSV (which is an altogether different dialogue).