Collection populated by Excel getting #NAME? for values

Hello,
I am using Excel > 'Get worksheet as range' and some of the values in excel that are calculated are appearing in my collection as '#NAME?'

How do I fix this?

If you open the worksheet manually, do you still the #NAME values? The #NAME value indicates 1) a function name is misspelled, or 2) a formula references a range of cells (example A1:Z5) and the colon is missing. I've sometimes seen a period (.) used instead of a colon. If you are providing the cell range as input, check that for typos also.