Share via

Power Pivot: Suddenly unable to drag related fields between tables to create relationships

Anonymous
2016-06-26T06:52:21+00:00

I am suddenly unable to drag related fields between tables to create relationships in Power Pivot relationship view

The line does not appear as I start dragging

I can still create the relationships manaully

I have Excel 2016 64 Bit  on a surface book

This is not file specific,  even the simplest 3 line tables cannot be connected this way any longer

Any thoughts?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

22 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-06-26T09:11:03+00:00

    Hi WynHopkins,

    Based on your description, please try the steps below to check whether the issue persists:

    1.Please ensure you have install the latest updates.

    2.Follow this article to repair Excel 2016: Repair an Office application.

    3.If repairing is not working, please use the Easy Fix tool in this article to completely uninstall Office and then reinstall Office: Uninstall Office 2016, Office 2013, or Office 365 from a PC.

    Regards,

    Fraser

    0 comments
  2. Anonymous
    2016-06-26T23:30:19+00:00

    Hi Fraser, tried all of that and still an issue I am now back to version

    16.0.6741.248  (Deferred).     Still no longer works on my machine or my colleague's who also has a surfacre book.

    It is working fine on exactly the same version but on a client's machine.

    I wondering if it's some sort of graphics display issue.

    0 comments
  3. Anonymous
    2016-06-27T09:41:38+00:00

    Hi WynHopkins,

    Based on your description, please try the steps below to check whether the issue persists:

    1. To start your surface in safe mode, you can refer to this article.

    2. If there are other add-ins in your Excel, disabled them to suppress interference. Go to File > Options > Add-Ins, in the Manage box, and then disabled the other add-ins.

    Regards,

    Vinson

    0 comments
  4. Anonymous
    2016-06-27T12:17:41+00:00

    Thanks Vinson

    Unfortunately I am unable to start Excel while in Windowos safe mode.

    (Although i did start it in low resolution mode and that had no impact)

    0 comments
  5. Anonymous
    2016-06-28T09:19:47+00:00

    Hi WynHopkins,

    In this case, I’d like to confirm whether you are using a Surface Pen with your Surface Book. If so, please try the steps below to check the outcome:

    1.Open Excel and go to File> Option> Advanced.

    2.In the Pen section, check the box next to Use pen to select and interact with content by default.

    If the issue persists, I’d like to collect some tenant information via private message. You can check it via https://answers.microsoft.com/en-us/privatemessages/list.

    Regards,

    Fraser

    0 comments