Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2018, 07:22 AM
ArviLaanemets ArviLaanemets is offline Excel 2016: A query from same workbook Windows 8 Excel 2016: A query from same workbook Office 2016
Expert
Excel 2016: A query from same workbook
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default 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?
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft