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.