Search found 13 matches

by gillyd123
Sun Jun 18, 2017 8:22 am
Forum: PowerPivot/DAX
Topic: One-to-One Relationships and Diagram View
Replies: 2
Views: 296

Re: One-to-One Relationships and Diagram View

Many thanks Matt - much appreciated.

GillyD
by gillyd123
Sun Jun 18, 2017 1:37 am
Forum: PowerPivot/DAX
Topic: One-to-One Relationships and Diagram View
Replies: 2
Views: 296

One-to-One Relationships and Diagram View

Hi All

How is it possible to create a 1-1 relationship in the data model AND have it show up in Diagram View?

Many thanks

GillyD
by gillyd123
Wed Dec 14, 2016 10:04 pm
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Hi Matt Received your email - many thanks for the update. I contributed to two threads on MS that I found whilst Googling for a solution: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/powerpivot-switch-to-table-preview-in-table/8b54844c-1fac-4c7c-a8fa-f449b4cc407e https...
by gillyd123
Fri Dec 09, 2016 3:33 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Hi

I am no further forward, I can't even add an Excel data file via From Other Sources into an empty data model - it crashes completely. Can anyone offer any help please?

Regards
Gill
by gillyd123
Thu Dec 08, 2016 12:02 am
Forum: PowerPivot/DAX
Topic: Edit Table Properties Problem
Replies: 11
Views: 2867

Re: Edit Table Properties Problem

Hi Daniel

Did you get anywhere with this? I have exactly the same problem on Excel 2016 and after 4 weeks of trying to find a resolution, nobody seems to know - not even Microsoft support??

Please share if you can throw some light.

Many thanks

Gilly
by gillyd123
Mon Dec 05, 2016 4:23 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Hi, I installed the runtime, rebooted. Tested on an existing data model and a new one with no joy I'm afraid. Sorry, Matt! I uninstalled/reinstalled Excel x64 and tried it with the 32bit version - and it's the same. However, having reinstalled 64bit Excel, it's not crashing when I import a simple Ex...
by gillyd123
Sun Dec 04, 2016 10:04 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

I'm using Standalone Excel, I'm a one man band, so I can't get Power Pivot any other way, unless I'm mistaken?? I have to find a solution to this via Power Pivot as I'm training that way, I would have to change all my user guide documentation and videos. Plus, I should be able to use it as is - I su...
by gillyd123
Sun Dec 04, 2016 9:23 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Just to add to the mix, since I've been importing Excel data - it crashes Excel. If I open a new workbook and import Access file, it's doesn't crash but I still only get Query Editor? I got so frustrated with this last week, I bought a new laptop, so I don't think it's due to a load of old junk hang...
by gillyd123
Sun Dec 04, 2016 8:15 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Right, when I tried to install I get an error msg about Click-to-Run apps aren't compatible - screenshot attached When I open a new workbook and install just an Excel file, it's exactly the same - no Table Preview, just Query Editor Thanks for this Matt, really appreciate your help - I'm pulling my ...
by gillyd123
Sun Dec 04, 2016 7:24 am
Forum: PowerPivot/DAX
Topic: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016
Replies: 16
Views: 2112

Re: Dropdown box greyed out in Table Properties - Power Pivot in Excel 2016

Hi Matt I've installed AccessRunTime X64 is that the right one? I'm on a 64bit laptop and Excel is 64bit. I have a colleague who is running 365 and he's having the same problem - just thought I'd mention that. I don't have MS Access on my machine either, but I'm guessing that's not a requirement to ...

Go to advanced search