Error: Cannot Place this file. No filter found for requested operation.

Hi all,

I have a catalogue design for a company where all the products info fields are edited as necessary in a spreadsheet. Whenever stocks/prices change these spreadsheets are edited by that department, I open the catalogue design .indd file and update the linked spreadsheets in the design with the 'modified links' prompt. This has been working brilliantly for a number of years now and keeps all the different departments happy with their roles in the updating process. 

I've opened the document this week and all the spreadsheet files are returning error symbols in the links panel. When I try to relink them, I recieve the error box "Cannot Place this file. No filter found for requested operation." 

The file types being linked are .xlsx files. I've tried opening the file in two versions of InDesign - Adobe InDesign CC 2019 (14.0.3) and Adobe InDesign 2020 (15.1.3) I've tried closing and relaunching and resaving the spreadsheets and turning the computer itself off and on again and am stumped. Any help appreciated!