When importing a sheet used in a named range, if the last row of the range is greater than the last row of the imported sheet, the named range resets to the last row of the imported sheet.
On the next import, if there are new rows, the range does not reset to all rows and queries setup with the named range do not evaluate all rows.
Any workaround?
