Forum Discussion

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 09, 2016
Solved

Drag and Drop Relationships in Power Pivot doesn't work with Excel 2016 and touch screen laptops

*****This issue has now been fixed (version 16.0.7167.2040) *******   This is a known issue and under invesigation but just a heads up in case you come across this issue   You can't use Drag and ...
BI & Data Analytics
Excel Desktop
  • Howie Dickerman's avatar
    Howie Dickerman
    Oct 13, 2016

    We still have an active bug on this issue, so it's not fully resolved, but we have identified that this problem is due to interactions with the device driver for a pen.  In the Device Manager, if you disable "Human Interface Devices / HID-compliant pen" and then restart Excel, I think you'll find that you can use both the mouse and touch to create relationships using drag-and-drop.

     

    Hope this helps,

    -Howie [Excel BI Program Manager]

James Fancke's avatar
James Fancke
Copper Contributor
Oct 11, 2016

I have just tried this in 16.0.7329.1015 64-bit and the issue is not resolved. Dragging to create relationships does not work with the mouse or trackpad, yet does work with touch. This is on a Surface Pro 3.

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Oct 12, 2016

James Fancke,  that is annoying.   I'm now using version 1609 (Build 7369.2024) on the Surface Book and a ThinkPad - both 64 bit and both are working.

 

Hopefully when you update next the issue will be resolved.

Resources