What's New in Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-748792%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B'%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGreat%20line%20up%20of%20new%20features%20...can%20not%20wait%20to%20get%20started%20w%2F%20them!%3C%2FP%3E%0A%3CP%3EChuck%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-758177%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758177%22%20slang%3D%22en-US%22%3EOffice%20Home%20%26amp%3B%20Business%202013%2C%20how%20can%20it%20become%20compatible%20with%20Excel%20-%20Power%20Pivot%2C%20what%20are%20your%20recommendations%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759004%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759004%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20Home%20%26amp%3B%20Business%202013%2C%20how%20can%20it%20become%20compatible%20with%20Excel%20-%20Power%20Pivot%2C%20what%20are%20your%20recommendations%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-759576%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-759576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F377386%22%20target%3D%22_blank%22%3E%40Jastarr01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20way%20is%20to%20update%20on%20one%20of%20versions%20with%20Power%20Pivot%2C%20please%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fwhere-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWhere%20is%20Power%20Pivot%3F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-779920%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-779920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3Enice%20post%2C%20I%20am%20looking%20forward%20to%20the%20new%20features%20of%20Excel!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20direct%20me%20to%20the%20reference%20page%20for%20the%20Excel%202016%20Sunburst%20Chart's%20objects%3F%26nbsp%3B%20I%20need%20to%20set%20the%20interior%20color%20of%20each%20data%20point%20in%20the%20chart%20with%20VBA.%26nbsp%3B%20Thanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-780615%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-780615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384539%22%20target%3D%22_blank%22%3E%40djpeterso23662%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3Bcan%20you%20help%3F%26nbsp%3B%20Thanks!%26nbsp%3B%20Cuong%26nbsp%3B%40%20Microsoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-781792%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384539%22%20target%3D%22_blank%22%3E%40djpeterso23662%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3BYou%20can%20look%20at%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foverview%2Fexcel%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EVBA%20Developers%20Reference%3C%2FA%3E%26nbsp%3Bfor%20starters.%20Regarding%20setting%20interior%20colors%2C%20see%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.thespreadsheetguru.com%2Fblog%2F2015%2F3%2F1%2Fthe-vba-coding-guide-for-excel-charts-graph%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.thespreadsheetguru.com%2Fblog%2F2015%2F3%2F1%2Fthe-vba-coding-guide-for-excel-charts-graph%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20me%2C%20the%20best%20way%20to%20expose%20objects%20and%20methods%20is%20to%20record%20a%20macro%20applying%20the%20changes%20you%20want.%20The%20recorder%20will%20capture%20it%2C%20then%20you%20can%20put%20that%20in%20your%20working%20code.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-831575%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-831575%22%20slang%3D%22en-US%22%3Ehi%20im%20looking%20fo%20some%20info%20in%20revoering%20a%20file%20that%20was%20accidentally%20deleted%20in%20excel%20does%20anyone%20know%20what%20i%20could%20possibly%20do%20to%20recover%20this%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881645%22%20slang%3D%22en-US%22%3ERe%3A%20What's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881645%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384539%22%20target%3D%22_blank%22%3E%40djpeterso23662%3C%2FA%3E%26nbsp%3BHere%20you%20go%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2F4a127977-62cd-4c11-b8c7-65b84a358e0c%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESunburst%20chart%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-748734%22%20slang%3D%22en-US%22%3EWhat's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748734%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20what's%20new%20in%20Microsoft%20Excel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22lia-align-center%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-microsoft-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23Audience%3DWindows_Desktop_%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWindows%20Desktop%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-microsoft-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23Audience%3DMac%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMac%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-microsoft-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23Audience%3DiOS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EiOS%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-microsoft-365-5fdb9208-ff33-45b6-9e08-1f5cdb3a6c73%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23Audience%3DAndroid%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAndroid%3C%2FA%3E%20%7C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhat-s-new-in-excel-for-the-web-f8f98d6b-4752-4119-a2aa-4de22ece8d81%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWeb%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-748734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722730%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722730%22%20slang%3D%22en-US%22%3Ehello%20is%20someone%20there%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1725431%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725431%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812668%22%20target%3D%22_blank%22%3E%40shardonaewest%3C%2FA%3E%2C%20how%20may%20we%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1736559%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736559%22%20slang%3D%22en-US%22%3EPlease%20help%20me.%20I'm%20struggling%20to%20find%20a%20Symbol.%20The%20question%20is%20-%20use%20the%20%22If%20statementstatem%22%20to%20insert%20Symbols%20from%20G2-G6.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1737709%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1737709%22%20slang%3D%22en-US%22%3E4m%20ago%20I%20picked%20this%20planner%20out%20of%20the%20templates%20but%20it%20has%202019%20year%2C%20how%20would%20I%20change%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1737728%22%20slang%3D%22en-US%22%3ERE%3A%20What's%20New%20in%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1737728%22%20slang%3D%22en-US%22%3Esorry%20I'm%20good%2C%20thank%20you.%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

See what's new in Microsoft Excel

 

Windows Desktop | Mac | iOS | Android | Web

12 Replies
Highlighted

@cuong '

 

Great line up of new features ...can not wait to get started w/ them!

Chuck


 


 

Highlighted
Office Home & Business 2013, how can it become compatible with Excel - Power Pivot, what are your recommendations
Highlighted

@Jastarr01 please see aka.ms/AA5mq8i and aka.ms/AA5mq8k. Hope that helps.

Highlighted

@Jastarr01 

 

The only way is to update on one of versions with Power Pivot, please see Where is Power Pivot?

Highlighted

@cuongnice post, I am looking forward to the new features of Excel!

 

Can you please direct me to the reference page for the Excel 2016 Sunburst Chart's objects?  I need to set the interior color of each data point in the chart with VBA.  Thanks so much!

Highlighted

@djpeterso23662 @Smitty Smith can you help?  Thanks!  Cuong @ Microsoft

Highlighted

@djpeterso23662 @cuong You can look at the VBA Developers Reference for starters. Regarding setting interior colors, see: https://www.thespreadsheetguru.com/blog/2015/3/1/the-vba-coding-guide-for-excel-charts-graph.

 

For me, the best way to expose objects and methods is to record a macro applying the changes you want. The recorder will capture it, then you can put that in your working code.

Highlighted
Highlighted
hello is someone there?
Highlighted
Hi @shardonaewest, how may we help?
Highlighted
4m ago I picked this planner out of the templates but it has 2019 year, how would I change that?
Highlighted
sorry I'm good, thank you.