View Single Post
 
Old 11-27-2020, 11:13 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 523
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Excel 2019 PQ shows error if source data is a range

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.
Reply With Quote