|
|
#1
11-27-2020, 11:13 PM
|
||||
|
||||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Excel range pasted into Word shows ##### instead of numbers
|
kjc | Excel | 7 | 05-10-2020 02:15 PM |
|
Merge same excel data source in two columns
|
Marcia | Mail Merge | 1 | 07-25-2019 02:27 PM |
| What's new in Word 2019, Excel 2019 and Outlook 2019 and Why upgrade to Office 2019 is recommended? | einfomail | Office | 0 | 07-25-2019 11:49 AM |
|
Excel data linked to external source
|
Doug Needham | Excel Programming | 1 | 09-15-2015 05:14 AM |
|
How can I revise Excel data source in merge?
|
navysalad | Mail Merge | 6 | 01-07-2012 06:50 PM |
Windows 7 32bit 
Office 2013
Threaded Mode