InDesign problem when placing an Excel table that is linked to another Excel table

[#1]

UPDATE: I have just today found out through testing that the issue is ONLY happening when the Excel file I'm using is pulling data from another Excel file. Specifically, InDesign will not pull data from excel if it’s a linked text value. Other data can be linked without issue.

I've encountered a problem with InDesign CC 2020 when placing a table from an Excel 2016 file.

My Excel file has data that it is pulling from another Excel file. There isn't any problem if I choose 'formatted table' when placing it - but as soon as I try to place it as an 'unformatted table' and apply any table style, there is an issue: the table shows "-1" whenever it should be showing either a blank cell, or a cell with only text in it.  

(I will be making 150 such tables in my InDesign file in this manner, and each table will frequently need to be updated, so it's important that I can get this to work if possible.)

[#2]

UPDATE: I have just today found out through testing that the issue is ONLY happening when the Excel file I'm using is pulling data from another Excel file. Specifically, InDesign will not pull data from excel if it’s a linked text value. Other data can be linked without issue.

I've encountered a problem with InDesign CC 2020 when placing a table from an Excel 2016 file.

My Excel file has data that it is pulling from another Excel file. There isn't any problem if I choose 'formatted table' when placing it - but as soon as I try to place it as an 'unformatted table' and apply any table style, there is an issue: the table shows "-1" whenever it should be showing either a blank cell, or a cell with only text in it.  

(I will be making 150 such tables in my InDesign file in this manner, and each table will frequently need to be updated, so it's important that I can get this to work if possible.)