I had been using a downloaded PQ in Excel 2013, Windows 7. I got the Windows and Excel upgraded from 7 to 10 and 2013 to 2019 respectively. To my dismay, the built in date picker is no longer available but I can live with that. My real headache is the PQ sends an error message regarding the data source which is a regular worksheet. I must convert it to table, something that I cannot do because the user form works with range not table.


Is there a workaround to force PQ to accept a range data source?
Thank you.

PQ needs an excel table to my knowledge (which is limited about PQ). there are articles on the web about using named ranges, but as a quick win could you just recreate (copy & paste linked data?) the data on another sheet and use that one for your the PQ and then extend the table manually as you add data to the non excel table?

Not great but might help until you can find a better fix

Thank you Purfleet. Will try the paste link but I must remember to adjust the area copied everytime a record is added. There was no problem with a range data source in Excel 2013.

PQ will work with a named range.
However, it's probably more robust to adjust the userform code to handle a table - tables are usually easier to write code for.

The thing is I just customized a downloaded form. My code writing skill is next to nill, although I tried a search on how to disable the autofilter in a named range.

Harry, unfortunately, no. I'm running the PQ 2 ways - through the paste link that Purfleet suggested and by keeping 2 Excel versions. 2013 with a downloaded PQ that allows regular sheets as data sources and the later version where I apply the paste link method.