Home

What's New in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-748734%22%20slang%3D%22en-US%22%3EWhat's%20New%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-748734%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fwhatsnewinxl%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%22%3Ewhat's%20new%20in%20Excel%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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-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%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%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%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
cuong
Microsoft

See what's new in Excel

 

Cuong

Microsoft

 

7 Replies
Highlighted

@cuong '

 

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

Chuck


 


 

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

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

@Jastarr01 

 

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

@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!

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

@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.