#1
|
|||
|
|||
Excel 2016: A query from same workbook
I have used this technique quite often for over 15 years. Lately there were some problems due me having 64 bit Windows and 32 bit MS Office, but there is a workaround.
Now I tried the same with Excel 2016 for 1st time. There are new ways to create a query added, but I did find at last the familiar "From MS Query" option too. But whatever way I did choose, no tables were displayed - not for "From MS Query" option, neither for other options. At last I opened the same file with Excel 2013 - and there were displayed all sheets in workbook, and the fixed named range I created before too (I prefer fixed named ranges as query source table). So the table itself was OK! Is there some setting to set, or what? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
Macro Personal Workbook does not load in Excel 2016 | Intruder | Excel Programming | 0 | 01-21-2017 05:44 AM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? | mag | Excel | 0 | 10-18-2012 11:15 AM |