Hi Erik,

Did you save the Excel file containing the query? What is the data source your query is connected to? Have you tried this with any other files that contain queries to see if this applies to all files or just this one?

Mynda

Hi Mynda

I have tried it with a number of files including a number of your course files - all saved on my laptop. Tried different folders, tried the "Data source" folder that Excel suggests, but every time with the same result.

Tried saving a new file in different folders - including the same folder as the source of the .odc-file - same result. In other words - it applies for all my files.

Now I have finished the next lesson - "4.22 - Data profiling", and the Data profiling tools does not appear on my menu bar.

I have searched the Microsoft Office web page, and there it says, that it should be available with Excel 2013, 2016, 2019 and 365. Searched for updates for my version, but according to Microsoft, I have got the latest version.

Erik

Hi Erik,

It sounds like your updates haven't been applied properly. Perhaps you could try repairing Office and or reinstalling it.

Mynda

Hi Mynda

First try was a repair through the control panel - no luck

Then I went the hard way with a reinstall - no luck

Have you got any ideas what to do? Sharing queries depends on this to some extent, so I would really like to find af fix

Erik

Hi Erik,

Can you please tell me the version number AND build number that you have installed now. And share the link to the Microsoft page where it says you should have these tools.

Thanks,

Mynda

Hi Mynda

I am at work now and have tested on Excel 2016 here - (16.0.4849.1000) 32-bit. MS Office 2016 Professionel Plus.

Here I cannot export an ODC-file, and I cannot see data profiling either.

Guess an update is slowly under way, and that my private version is a step or two ahead.

This i a link to MS webpage, where the information at the top states, that data profiling should be in Excel 2013, 2016, 2019 and 365:

https://support.office.com/en-ie/article/find-data-issues-in-the-power-query-editor-79616636-43aa-428f-b14b-f9c5c060f6b2

Erik

Hi again

My private Excel 2016 is a part of Microsoft Office Professional Plus 2016 - and Excel is Version 2004 - Build 12730.20270.

Erik

Hi Erik,

I've escalated it with Microsoft. I'll let you know what they say. I have a feeling that post is incorrectly listing Excel 2013 and 2016 as having data profiling, but we'll see.

Mynda

Hi Mynda

Thanks a lot

I guess you are right - but still strange, that I can save .odc-files but not use them.

Erik

Hi again

Found the Microsoft webpage describing use / import of .odc-files in Excel 2010, 2013, 2016, 2019 and 365.

https://support.office.com/en-us/article/Connect-to-Import-external-data-9967afd8-85ee-4df3-aa06-753bcc1a2724

Erik

Thanks for the link, Erik. I'll pass it on to Microsoft and let you know as soon as I hear back.

Hi again Mynda

It seems to me, that Microsoft isn't going to answer this one.

I understand that developement is for Excel 365 users only, but I was hoping that my 2016-version eventually would benefit from that in regards of new formulas ( Xlookup, Unique, Switch and others ) as well as new features.

Just a note - My companye uses Office 2016, and for various reasons we will not be using 365.

Erik

Hi Eric,

The only guarantee of getting new features is to use the 365 versions of Office. Any perpetual licences typically only get bug fixes. If it's any consolation, it's well worth getting the 365 license.

Mynda

Hi Mynda

I understand that, but it wouldn't make a whole lot of sense to me to buy the 365 version, when my comany ( with more than 11.000 employees ) has chosen 2016.

So I will have to settle for my "limited" version.

Erik