Home

How can I get the new feature "Insights"?

%3CLINGO-SUB%20id%3D%22lingo-sub-192920%22%20slang%3D%22en-US%22%3EHow%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-192920%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20a%20user%20of%20Office%20365%20Home%20and%20I%20joined%20the%20Insider%20plan.%20My%20Office%20version%20is%201806%20now.%3C%2FP%3E%3CP%3EBut%20I%20can't%20see%20%22insights%22%20in%20the%20%22Insert%22%20tab%2C%20why%20%3F%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-192920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-423271%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-423271%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20i%20am%20using%20Office%20Pro%20plus%202019%20version%201903.%20this%20is%20the%20latest%20version%20but%20i%20dont%20have%20Insights%20option%20in%20my%20excel.%20can%20you%20support%3F%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228035%22%20target%3D%22_blank%22%3E%40Pet0r%20Czechowski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-272095%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-272095%22%20slang%3D%22en-US%22%3E%3CP%3EPeter%2C%20another%20option%20which%20could%20work%20in%20some%20situations%20if%20you%20unchek%20compatibility%20view%20in%20IE%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271550%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271550%22%20slang%3D%22en-US%22%3E%3CP%3EPeter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOkay%2C%20thank%20you%20for%20the%20clarification.%3C%2FP%3E%3CP%3EInsights%20will%20be%20substituted%20on%20Ideas%2C%20but%20my%20understanding%20they%20are%20working%20the%20same%20way.%3C%2FP%3E%3CP%3EWhen%20you%20click%20on%20the%20icon%20it%20shall%20be%20no%20any%20buttons%20in%20the%20pane.%20If%20you%20have%20any%20data%20within%20the%20sheet%2C%20in%20the%20pane%20it%20will%20be%20suggestion%20for%20this%20and%20that%20graph%20to%20insert.%20If%20you%20have%20no%20data%20in%20the%20sheet%2C%20in%20the%20pane%20it'll%20be%20the%20message%20what%20Insight%20can't%20recognize%20your%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20only%20white%20box%20without%20any%20information%20that%20most%20probably%20means%20Excel%20can't%20communicate%20with%20the%20server%20on%20Microsoft%20site.%20In%20general%20that's%20a%20bug%20if%20only%20your%20firewall%20doesn't%20block%20such%20connection.%20The%20only%20workaround%20I%20know%20is%20to%20add%20%3CA%20href%3D%22https%3A%2F%2Finsights.microsoft.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsights.microsoft.com%3C%2FA%3E%20to%20the%20list%20of%20trusted%20sites%3A%20Internet%20Explorer-%26gt%3BTools-%26gt%3BInternet%20Options-%26gt%3BSecurity-%26gt%3BTrusted%20sites-%26gt%3BSites.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271542%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271542%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20the%20same%20issue%20as%20the%20one%20Kevin%20had%20above%20in%20the%20screenshot%20which%20he%20squared%20in%20Red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit's%20insight%2C%20it%20appears%20as%20a%20white%20box%20with%20no%20button%20in%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271500%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271500%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Peter%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20mean%20you%20have%20empty%20white%20pane%20on%20the%20right%20without%20any%20information%3F%20And%20is%20that%20Insights%20icon%20or%20new%20Ideas%20icon%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%3C%2FA%3E%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271414%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271414%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20this%20same%20issue%20with%20a%20clients%20computer.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThey%20are%20using%20ProPlus%20version%20of%20office%20365%20on%20the%20latest%20version%20%22%3CEM%3EVersion%201809%20(Build%2010827.20150)%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20adding%20insights%2C%20it%20appears%20blank%20with%20no%20button%20to%20press.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%2CPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193284%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193284%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193263%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193263%22%20slang%3D%22en-US%22%3EHi%20Kevin%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20Sergei%20and%20the%20website%20says%2C%20it'll%20be%20coming%20but%20I'm%20sure%20you%20won't%20have%20to%20wait%20long.%20Microsoft%20are%20efficient%20at%20pushing%20stuff%20out.%3CBR%20%2F%3E%3CBR%20%2F%3EGood%20luck%20with%20it.%20I%20hope%20it%20does%20the%20job%20for%20you%20when%20you%20get%20it!%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EDamien%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193245%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193245%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20I'm%20using%20English%20version%20and%20I've%20joined%20Insider%20plan.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193244%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193244%22%20slang%3D%22en-US%22%3E%3CP%3ESo%2C%20I%20can%20only%20do%20wait%20%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193218%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193218%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20functionality%20is%20distributed%20gradually.%20If%20you%20are%20on%20the%20build%20for%20which%20the%20functionality%20was%20announced%20that's%20not%20necessary%20you'll%20have%20it%2C%20maximum%20you%20may%20have%20that's%20that%20grey%20icon.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20way%20is%20to%20wait%20till%20it'll%20be%20activated%20for%20your%20pool.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193167%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193167%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20what's%20happening%20with%20your%20subscription%20and%20I%20don't%20have%20the%20option%20either%20in%20my%20ProPlus.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20some%20info%20from%20the%20Microsoft%20site%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsights-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-ie%2Farticle%2Finsights-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20says%20it's%20still%20rolling%20out%20but%20that%20you%20as%20an%20Insider%20should%20get%20first%20offering%20if%20you%20are%20using%20the%20English%20version.%20If%20you're%20not%20using%20the%20English%20version%20then%20maybe%20that%20might%20be%20the%20cause.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOther%20than%20that%2C%20maybe%20someone%20else%20here%20knows%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193165%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193165%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20help.%3C%2FP%3E%3CP%3EI%20did%20what%20you%20said%20but%20only%20get%20this.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34031iD3DF2B857CB41FF6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20180514112209.png%22%20title%3D%22%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87_20180514112209.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-193129%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-193129%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Kevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20need%20to%20just%20add%20it%20to%20the%20%3CSTRONG%3EInsert%3C%2FSTRONG%3E%20menu%20by%20%3CSTRONG%3ECustomizing%20the%20Ribbon%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20826px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34022i320485DEC4F25679%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22addinsights.png%22%20title%3D%22addinsights.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20try%20this%20and%20see%20if%20it%20works%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-424203%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20get%20the%20new%20feature%20%22Insights%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-424203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318261%22%20target%3D%22_blank%22%3E%40jawadmasood%3C%2FA%3E%26nbsp%3B%2C%20Ideas%20is%20only%20for%20Office%20365%20subscribers%2C%20at%20least%20based%20on%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
周庆麟 -Kevin Zhou-
Occasional Contributor

I'm a user of Office 365 Home and I joined the Insider plan. My Office version is 1806 now.

But I can't see "insights" in the "Insert" tab, why ?

How can I get it?

15 Replies

Hi Kevin

 

You may need to just add it to the Insert menu by Customizing the Ribbon.

 

addinsights.png

 

Maybe try this and see if it works?

 

Best of luck!

 

Cheers

Damien

Thanks for help.

I did what you said but only get this.

微信图片_20180514112209.png

Hi Kevin

 

I'm not sure what's happening with your subscription and I don't have the option either in my ProPlus.

 

Here's some info from the Microsoft site: https://support.office.com/en-ie/article/insights-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4 

 

It says it's still rolling out but that you as an Insider should get first offering if you are using the English version. If you're not using the English version then maybe that might be the cause.

 

Other than that, maybe someone else here knows something?

 

Best wishes

Damien

That functionality is distributed gradually. If you are on the build for which the functionality was announced that's not necessary you'll have it, maximum you may have that's that grey icon.

 

The only way is to wait till it'll be activated for your pool.

So, I can only do wait ? 

Yes, I'm using English version and I've joined Insider plan.

Hi Kevin

As Sergei and the website says, it'll be coming but I'm sure you won't have to wait long. Microsoft are efficient at pushing stuff out.

Good luck with it. I hope it does the job for you when you get it!

Cheers
Damien

Hello,

 

I'm having this same issue with a clients computer.


They are using ProPlus version of office 365 on the latest version "Version 1809 (Build 10827.20150)"

 

But when adding insights, it appears blank with no button to press.

 

Any help would be appreciated.


Thanks,
Peter

Hi Peter,

 

Do you mean you have empty white pane on the right without any information? And is that Insights icon or new Ideas icon https://support.office.com/en-us/article/ideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4 ?

Hey Sergei,

 

It's the same issue as the one Kevin had above in the screenshot which he squared in Red.

 

it's insight, it appears as a white box with no button in it.

Peter,

 

Okay, thank you for the clarification.

Insights will be substituted on Ideas, but my understanding they are working the same way.

When you click on the icon it shall be no any buttons in the pane. If you have any data within the sheet, in the pane it will be suggestion for this and that graph to insert. If you have no data in the sheet, in the pane it'll be the message what Insight can't recognize your data.

 

If you have only white box without any information that most probably means Excel can't communicate with the server on Microsoft site. In general that's a bug if only your firewall doesn't block such connection. The only workaround I know is to add https://insights.microsoft.com to the list of trusted sites: Internet Explorer->Tools->Internet Options->Security->Trusted sites->Sites.

Peter, another option which could work in some situations if you unchek compatibility view in IE

hi, i am using Office Pro plus 2019 version 1903. this is the latest version but i dont have Insights option in my excel. can you support? @Pet0r Czechowski