Table Properties – No Table Preview just Query Editor

eliwaite

New Member
Joined
Feb 24, 2015
Messages
30
I am using Office 2016 64 bit and running into a problem with the Table Properties in PowerPivot. When I import a file (from Excel), but forget to include, exclude a column or set a filter correctly on the initial import I use to be able to go to Design->Table Properties and modify the import. Recently though, the only option I get is the Query Editor. Does anyone know how to get the Table Preview back? I created a short video showing what I am running up against if you are having trouble understanding what I am trying to explain https://www.youtube.com/watch?v=H0hoAjG1s4Q&feature=youtu.be
 

Matt Allington

MrExcel MVP
Joined
Dec 18, 2014
Messages
1,192
I have all 3 versions of Excel with Power Pivot. I just completed a test using all 3. It works fine in 2010 and 2013, but it does not work for Excel 2016. This is a clear bug. You should contact Microsoft support at https://answers.microsoft.com/
 

Forum statistics

Threads
1,086,122
Messages
5,387,975
Members
402,092
Latest member
S_S

Some videos you may like

This Week's Hot Topics

Top