Is this new? I made queries 7 months ago and within the past 2 weeks I've been getting random duplicates.
The query brings in about 50 sheets worth of data, and there might be 1 or 2 that are duplicated. I just noticed this activity in the image below. The duplicate is happening on this file because Sheet1 is being imported as well as _xlnm.Print_Area.
When I go filter that print area out, everything is fine.
I don't know if I just missed something 7 months ago; if the workbook user did something; or if Microsoft changed something.
Any ideas where I can begin to look for what's different?
The query brings in about 50 sheets worth of data, and there might be 1 or 2 that are duplicated. I just noticed this activity in the image below. The duplicate is happening on this file because Sheet1 is being imported as well as _xlnm.Print_Area.
When I go filter that print area out, everything is fine.
I don't know if I just missed something 7 months ago; if the workbook user did something; or if Microsoft changed something.
Any ideas where I can begin to look for what's different?