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%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%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%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%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%22%3ESunburst%20chart%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E
cuong
Microsoft

See what's new in Excel

 

Cuong

Microsoft

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 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
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies