Home

Installed Excel v1902 on March 4, But No "Ideas for Excel". Why?

%3CLINGO-SUB%20id%3D%22lingo-sub-363446%22%20slang%3D%22en-US%22%3EInstalled%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363446%22%20slang%3D%22en-US%22%3E%3CP%3EAre%20there%20components%20needed%20that%20my%20company%20doesn't%20provide%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-363446%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369608%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369608%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mark%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20some%20delay%20with%20answer.%20I%20didn't%20find%20what%20exactly%20your%20error%20in%20Excel%20Online%20means.%20In%20any%20case%20new%20functionality%20could%20exist%20in%20Excel%20Online%20and%20not%20in%20Excel%20Desktop.%20As%20for%20the%20release%20notes%20that%20only%20means%20what%20the%20code%20with%20such%20new%20functionality%20is%20included%20into%20Excel%20desktop%20starting%20from%20that%20build.%20But%20that%20doesn't%20mean%20it%20will%20be%20switched%20on%20as%20soon%20as%20you%20upgraded%20on%20that%20build.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364414%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364414%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%2C%20I%20attached%20a%20PNG%20showing%20the%20error.%26nbsp%3B%20I'm%20referring%20to%20our%20Excel%20Online%20to%20demonstrate%20the%20availability%20of%20this%20feature%20in%20our%20tenant.%26nbsp%3B%20I%20suspect%20that%20our%20proxies%20are%20not%20set%20properly%20for%20use%20within%20our%20firewall.%26nbsp%3B%20I%20have%20a%20service%20ticket%20opened%20for%20our%20MS%20Office%20support%20team.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20the%20release%20notes%20for%20Excel%20version%201902%2C%20this%20feature%20is%20available%20now.%26nbsp%3B%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fmonthly-channel-2019%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fmonthly-channel-2019%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364403%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364403%22%20slang%3D%22en-US%22%3E%3CP%3EMark%2C%20I%20didn't%20try%20Ideas%20with%20Excel%20Online%20(practically%20don't%20work%20with%20it)%2C%20but%20will%20check%20bit%20later.%20Which%20exactly%20error%20do%20you%20have%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20desktop%20version%20it's%20coming.%20Microsoft%20usually%20announce%20some%20functionality%20for%20the%20build%2C%20after%20that%20starts%20slowly%20deploy%20it%20among%20tenants.%20Build%20number%20actually%20means%20only%20you%20definitely%20won't%20have%20such%20functionality%20on%20earliest%20build.%20For%20this%20very%20build%20and%20next%20ones%20-%20it%20depends.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364351%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364351%22%20slang%3D%22en-US%22%3ESergei%2C%20thanks%20for%20the%20reply.%20I%20can%20access%20our%20Excel%20Online%20using%20both%20IE%2011%20w%2F%20the%20Compatibility%20View%20set%20as%20you%20show%20above%2C%20and%20using%20Chrome%20version%2072.0.3626.121.%20In%20both%20cases%20I%20can%20see%20the%20%22blue%20lightening%20bolt%22%20on%20the%20Home%20ribbon%2C%20but%20when%20it's%20pressed%20I%20get%20an%20error%20message%20in%20the%20Ideas%20Preview%20panel.%20For%20my%20desktop%20Excel%20version%201902%20I%20don't%20see%20the%20%22blue%20lightening%20bolt%22%20at%20all.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363719%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363719%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%3EHi%2C%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EI%20think%20the%20feature%20has%20not%20yet%20been%20enabled%20on%20your%26nbsp%3B%3CFONT%3Eyour%20tenant.%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%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%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%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3BThis%20feature%20is%20being%20made%20available%20to%20customers%20on%20a%20gradual%20basis.%20It%20will%20first%20be%20available%20in%20English%2C%20French%2C%20Spanish%2C%20German%2C%20Simplified%20Chinese%2C%20and%20Japanese%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fproducts.office.com%2Fbuy%2Fcompare-microsoft-office-products%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20365%20subscribers%3C%2FA%3E%3CSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eon%20Windows%20and%20Mac.%20If%20you%20are%20an%20Office%20365%20subscriber%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fhow-do-i-upgrade-office-ee68f6cf-422f-464a-82ec-385f65391350%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Emake%20sure%20you%20have%20the%20latest%20version%20of%20Office%3C%2FA%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363695%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363695%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mark%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20clarify%20you%20don't%20have%20Ideas%20icon%20at%20all%2C%20or%20you%20have%20it%20and%20it%20doesn't%20work%20and%20you%20have%20only%20white%20pane%20when%20you%20click%20on%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20Ideas%20is%20not%20an%20add-in%2C%20that%20is%20built-in%20functionality%20like%2C%20for%20example%2C%20modern%20Data%20Types%20(Stock%20and%20Geography).%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20first%2C%20it's%20most%20probably%20wasn't%20deployed%20for%20your%20tenant.%20If%20second%2C%20you%20need%20to%20play%20with%20IE%20security%20settings%20and%2For%20compatibility%20view.%20What%20helped%20to%20me%20that's%20uncheck%20of%20the%20latest%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20407px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86309i98F50DAAFC0C3005%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363595%22%20slang%3D%22en-US%22%3ERe%3A%20Installed%20Excel%20v1902%20on%20March%204%2C%20But%20No%20%22Ideas%20for%20Excel%22.%20Why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363595%22%20slang%3D%22en-US%22%3EI've%20been%20doing%20some%20research%2C%20and%20now%20I%20believe%20that%20our%20Office%20365%20Admin%20has%20not%20enabled%20App%20add-ins.%20Would%20that%20prevent%20the%20proper%20functioning%20of%20the%20Ideas%20in%20Excel%20feature%3F%20If%20so%2C%20how%20can%20I%20influence%20a%20policy%20change%3F%20For%20example%2C%20if%20cost%20is%20an%20issue%20is%20it%20possible%20to%20only%20enable%20free%20App%20add-ins%2C%20and%20would%20that%20be%20sufficient%20to%20get%20Ideas%20in%20Excel%20working%3F%3C%2FLINGO-BODY%3E
Mark E Weisman
Occasional Contributor

Are there components needed that my company doesn't provide?

7 Replies
I've been doing some research, and now I believe that our Office 365 Admin has not enabled App add-ins. Would that prevent the proper functioning of the Ideas in Excel feature? If so, how can I influence a policy change? For example, if cost is an issue is it possible to only enable free App add-ins, and would that be sufficient to get Ideas in Excel working?

Hi Mark,

 

Please clarify you don't have Ideas icon at all, or you have it and it doesn't work and you have only white pane when you click on it.

 

IMHO, Ideas is not an add-in, that is built-in functionality like, for example, modern Data Types (Stock and Geography). 

 

If first, it's most probably wasn't deployed for your tenant. If second, you need to play with IE security settings and/or compatibility view. What helped to me that's uncheck of the latest

image.png

 

Hi,

I think the feature has not yet been enabled on your your tenant.

https://support.office.com/en-us/article/ideas-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4

Note: This feature is being made available to customers on a gradual basis. It will first be available in English, French, Spanish, German, Simplified Chinese, and Japanese to Office 365 subscribers on Windows and Mac. If you are an Office 365 subscriber, make sure you have the latest version of Office.

Sergei, thanks for the reply. I can access our Excel Online using both IE 11 w/ the Compatibility View set as you show above, and using Chrome version 72.0.3626.121. In both cases I can see the "blue lightening bolt" on the Home ribbon, but when it's pressed I get an error message in the Ideas Preview panel. For my desktop Excel version 1902 I don't see the "blue lightening bolt" at all.

Mark, I didn't try Ideas with Excel Online (practically don't work with it), but will check bit later. Which exactly error do you have?

 

As for the desktop version it's coming. Microsoft usually announce some functionality for the build, after that starts slowly deploy it among tenants. Build number actually means only you definitely won't have such functionality on earliest build. For this very build and next ones - it depends.

Sergei, I attached a PNG showing the error.  I'm referring to our Excel Online to demonstrate the availability of this feature in our tenant.  I suspect that our proxies are not set properly for use within our firewall.  I have a service ticket opened for our MS Office support team.

 

According to the release notes for Excel version 1902, this feature is available now.  See https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2019

Highlighted

Hi Mark,

 

Sorry for some delay with answer. I didn't find what exactly your error in Excel Online means. In any case new functionality could exist in Excel Online and not in Excel Desktop. As for the release notes that only means what the code with such new functionality is included into Excel desktop starting from that build. But that doesn't mean it will be switched on as soon as you upgraded on that build.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies