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]

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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 12, 2016

I'm on build 1609.7369.2024, 64 bit - and that doesn't work on my Surface 3 Pro, checked right now. Touch only drag&drop.  

Resources