The workaround would be to export your named range from excel as a flat file, or re-create the conditions in post-processing after import of the non-dynamic range in FileMaker.
I would not expect FM (or ANY program aside from excel) to recognize dynamic ranges. It's more of a program feature, not a file format feature.
Are you doing a recurring import from said excel document, or using it as a data source?
Here is an update:
I removed the dynamic ranges fromt he spreadhseet and instead created 2 standard ranges; they work.
When I run the import script with the "PERFORM WITHOUT DIALOG" box *NOT* checked, FM prompts
for the range. I select it and all is well.
However, if I check "PERFORM WITHOUT DIALOG", FM fails to remember the previously selected range
and seems to select only the 1st range.
Question: "Is there a way to get FM to remember the previously selected Range?