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
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]

Howie Dickerman

Former Employee

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

MVP

Oct 21, 2016

Just came across this issue on another laptop, applied Howie Dickerman's fix and it solved the issue.

Thanks Howie

Forum Discussion

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

Resources