SOLVED

How your ideas on Excel.uservoice.com help improve Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1587802%22%20slang%3D%22en-US%22%3ERe%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587802%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20sharing.%20By%20the%20way%2C%20I%20guess%20this%20one%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F32223604-pull-current-stock-prices-and-historical-data-into%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPull%20Current%20Stock%20Prices%20and%20Historical%20Data%20Into%20Excel%3C%2FA%3E%26nbsp%3Balso%20could%20be%20closed%2C%20it's%20still%20in%20Started%20status%20from%20Dec%202018.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1597485%22%20slang%3D%22en-US%22%3ERe%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597485%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20update%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E.%26nbsp%3BIs%20good%20to%20see%20this%20changelog%20associated%20with%20UserVoice%2C%20so%20we%20can%20see%20better%20the%20dimension%20of%20that%20channel%20on%20the%20improvements.%20Do%20you%20have%20some%20information%20about%20these%202%20suggestions%20below%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EIdeas%20in%20Excel%20for%20Mobile%2C%20so%20we%20could%20have%20insights%20in%20the%20palm%20of%20our%20hands%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304936-excel-for-mobile-devices-tablets-phones-android%2Fsuggestions%2F40402936-ideas-in-excel-for-mobile%22%20target%3D%22_blank%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304936-excel-for-mobile-devices-tablets-phones-android%2Fsuggestions%2F40402936-ideas-in-excel-for-mobile%3C%2FA%3E%3C%2FLI%3E%3CLI%3EA%20FILTERJSON%20function%2C%20since%20JSON%20format%20is%20a%20trend%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F38927962-please-create-a-filterjson-filtrojson-worksheet%22%20target%3D%22_blank%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F38927962-please-create-a-filterjson-filtrojson-worksheet%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1597544%22%20slang%3D%22en-US%22%3ERe%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1597544%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHi%20Steve%2C%3CBR%20%2F%3E%3CBR%20%2F%3ENice%20post.%20Does%20the%20Excel%20team%20incorporate%20the%20Excel.UserVoice.com%20into%20its%20Road-Map%20for%20excel%3F%3CBR%20%2F%3EThere%20are%20currently%206%20product%20suggestions%20in%20the%20top%2010%20that%20have%20a%20status%20of%20%22accepting%20votes%22.%3CBR%20%2F%3E%3CBR%20%2F%3ESome%20of%20these%20suggestions%20in%20the%20top%2010%20have%20been%20open%20since%202015%20to%20no%20success.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EAs%20you%20have%20indicated%20in%20your%20previous%20post%20the%20site%20doesn't%20currently%20capture%20what%20has%20been%20taken%20into%20consideration.%26nbsp%3BMight%20I%20suggest%20that%20your%20team%20implement%20a%20similar%20approach%20to%20the%20experience.dynamics.com%20product%20suggestions.%3CBR%20%2F%3E%3CBR%20%2F%3EWhere%20by%20each%20suggestion%20is%20tagged%20with%20a%20status%20of%20%22Completed%22%2C%20%22In%20Review%22%2C%20%22Needs%20Votes%22.%3CBR%20%2F%3EThis%20would%20then%20assist%20your%20team%20in%20focusing%20on%20some%20of%20the%20higher%20voted%20items%2C%20and%20would%20also%20provide%20more%20visibility%20to%20users.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20would%20also%20provide%20the%20visibility%20that%20you%20described%20of%20features%20your%20team%20has%20completed%20suggestions%20that%20%22make%20excel%20better%22.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bleddyn_James_1-1597789948043.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213208iE863F3FB5CC64BAA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bleddyn_James_1-1597789948043.png%22%20alt%3D%22Bleddyn_James_1-1597789948043.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EAre%20you%20able%20to%20shed%20any%20light%20on%20when%20the%20Conditional%20Formatting%20applied%20to%20named%20ranges%20is%20likely%20to%20be%20incorporated%20into%20future%20versions%3F%3CBR%20%2F%3EIt%20would%20be%20great%20to%20understand%20where%20this%20is%20in%20the%20Excel%20teams%20Road-Map%20as%20it%20is%20one%20of%20the%20most%20voted%20items%2C%20has%20been%20open%20since%202015%20and%20still%20has%20a%20status%20of%20%22Accepting%20Votes%22.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10561194-conditional-formatting-apply-to-named-ranges%3Ftracking_code%3Df015379b2ae2bf966f435f01df692cb9%22%20target%3D%22_blank%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10561194...%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20look%20forward%20to%20hearing%20from%20you.%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EBleddyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1611764%22%20slang%3D%22en-US%22%3ERE%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1611764%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20a%20formula%20can%20someone%20advise%20me%3F%20I%20am%20not%20sure%20even%20on%20the%20function%20to%20use%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612028%22%20slang%3D%22en-US%22%3ERE%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770942%22%20target%3D%22_blank%22%3E%40Jenny895%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20if%20you%20ask%20the%20question%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%26nbsp%3Busing%20Start%20New%20Conversation%20button.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1613380%22%20slang%3D%22en-US%22%3ERE%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1613380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F770942%22%20target%3D%22_blank%22%3E%40Jenny895%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20best%20way%20to%20get%20help%20is%20to%20post%20your%20question%20in%20the%20Excel%20area%2C%20explaining%20the%20problem%20you%20need%20to%20solve.%20If%20you%20can%20provide%20an%20example%2C%20it%20will%20be%20easier%20for%20anyone%20who%20jumps%20in%20to%20try%20to%20help%20you.%3C%2FP%3E%3CP%3EPost%20your%20question%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1637467%22%20slang%3D%22en-US%22%3ERE%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637467%22%20slang%3D%22en-US%22%3EBuenos%20dias%2C%20de%20antemano%20muy%20agradecido%20por%20la%20respuesta%20que%20me%20puedan%20ofrecer%2C%20es%20la%20primera%20vez%20que%20ingreso%20a%20este%20sitio%20web%20y%20creo%20que%20nos%20brindan%20ayuda%20muy%20valiosa%2C%20les%20comento%20mi%20dificulta%20en%20escel%2C%20me%20sale%20el%20siguiente%20mensaje%3A%20%22excel%20no%20se%20puede%20utilizar%20la%20formula%20especificada%20porque%20contiene%20mas%20valores%20referencias%20o%20nombres%20de%20los%20permitidos%20en%20el%20formato%20de%20archivo%20actual%22%2C%20tengo%20una%20tabla%20din%C3%A1mica%20tiene%204%20columnas%20(estoy%20trabajando%20en%20excel%202003-2007%2C%20asi%20me%20alcanzaron%20el%20archivo)%2C%20mi%20objetivo%20es%20conocer%20si%20la%20fila%20es%20decir%20el%20valor%20contenido%20en%20cada%20celda%20de%20la%20fila%20son%20iguales%20y%20para%20ello%20utilizo%20la%20funci%C3%B3n%20SI(Y(_%3B_%3B_%3B_%3B_%3B_)%3B1%3B0)%20no%20me%20deja%20comparar%20en%20Y%20mas%20de%205%20argumentos%2C%20deseo%20comparar%20mas%20poner%20aqu%C3%AD%20Y(_%3B_%3B_%3B_%3B)%20mas%20de%20cinco%20pero%20no%20me%20permite%2C%20bueno%20eso%20es%20lo%20que%20deseaba%20comentar%20ojala%20me%20puedan%20ayudar%2C...%2C%20muy%20agradecido%20por%20su%20tiempo%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1637476%22%20slang%3D%22en-US%22%3ERE%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782758%22%20target%3D%22_blank%22%3E%40Flavio_1355%3C%2FA%3E%26nbsp%3B%3CSPAN%3EPor%20favor%2C%20publique%20su%20pregunta%20en%3A%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22t_underline%22%20href%3D%22https%3A%2F%2Fssl.microsofttranslator.com%2Fbv.aspx%3Fref%3DTAns%26amp%3Bfrom%3D%26amp%3Bto%3Des%26amp%3Ba%3Dhttps%253A%252F%252Ftechcommunity.microsoft.com%252Ft5%252Fexcel%252Fbd-p%252FExcelGeneral%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%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%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1650850%22%20slang%3D%22en-US%22%3ERe%3A%20How%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1650850%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20able%20to%20shed%20some%20light%20on%20what%20%22not%20at%20this%20time%22%20means%3F%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10561194-conditional-formatting-apply-to-named-ranges%3Ftracking_code%3Dc5505047dc2b47fcc97d4a78792d572a%23%7Btoggle_previous_statuses%7D%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10561194-conditional-formatting-apply-to-named-ranges%3Ftracking_code%3Dc5505047dc2b47fcc97d4a78792d572a%23%7Btoggle_previous_statuses%7D%3C%2FA%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bleddyn_James_0-1599687510364.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217383i72C72ABF88982510%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bleddyn_James_0-1599687510364.png%22%20alt%3D%22Bleddyn_James_0-1599687510364.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20has%20been%20a%20product%20suggestion%20for%20almost%205%20YEARS!%3CBR%20%2F%3EIf%20%22not%20at%20this%20time%22%20when%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20one%20of%20the%20most%20voted%20items%20not%20only%20in%20its%20category%20but%20across%20the%20excel%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResponding%20by%20saying%20%22it's%20in%20the%20too%20hard%20basket%22%20is%20not%20a%20valid%20response.%3C%2FP%3E%3CP%3EPlease%20provide%20an%20ETA%2Froad%20map%20of%20when%20you%20actually%20intend%20to%20resolve%20this%20product%20suggestion!%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20absolutely%20no%20point%20in%20users%20using%20the%20voting%20system%20of%20forum%20if%20they%20are%20simply%20going%20to%20be%20ignored.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3CBR%20%2F%3EBleddyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587487%22%20slang%3D%22en-US%22%3EHow%20your%20ideas%20on%20Excel.uservoice.com%20help%20improve%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587487%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThank%20you%20for%20%3C%2FSPAN%3E%3CSPAN%3Esharing%20your%20ideas%20and%20suggestions%20%3C%2FSPAN%3E%3CSPAN%3Eon%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%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%22%3EExcel.uservoice.com%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%3E!%3C%2FSPAN%3E%3CSPAN%3E%20Your%20%3C%2FSPAN%3E%3CSPAN%3Econtinued%20%3C%2FSPAN%3E%3CSPAN%3Einput%20and%20feedback%20%3C%2FSPAN%3E%3CSPAN%3Ehelp%20%3C%2FSPAN%3E%3CSPAN%3Emake%20%3C%2FSPAN%3E%3CSPAN%3EMicrosoft%20Excel%20%3C%2FSPAN%3E%3CSPAN%3Ebetter%20every%20day.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThe%20list%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bbelow%20%3C%2FSPAN%3E%3CSPAN%3Eshows%20%3C%2FSPAN%3E%3CSPAN%3Ehow%20you%E2%80%99ve%20helped%20%3C%2FSPAN%3E%3CSPAN%3Eimprove%20%3C%2FSPAN%3E%3CSPAN%3EExcel%3C%2FSPAN%3E%3CSPAN%3E%20%E2%80%93%20click%20on%20the%20title%3C%2FSPAN%3E%3CSPAN%3E%20to%20learn%20more%20about%20each%20item%3C%2FSPAN%3E%3CSPAN%3E.%20We'll%20continue%20adding%20to%20this%20list%3C%2FSPAN%3E%3CSPAN%3E.%20Subscribe%20to%20this%20post%20to%20get%20the%20latest%20update.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F40687084%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMoney%20in%20Excel%3A%20Multiple%20Accounts%20Per%20Institution%3C%2FA%3E%2C%2013-Oct-2020%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F38496496%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERelease%20XLOOKUP%20to%20the%20world!%3C%2FA%3E%2C%207-Oct-2020%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F40110274%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFixed%3A%20When%20I%20click%20through%20multiple%20tabs%20in%20Excel%20Online%2C%20the%20tabs%20get%20re-arranged%3C%2FA%3E%2C%2022-Sep-2020%2C%20Web%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F40858108%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ERemove%20the%20lock%20symbols%20from%20the%20tabs%20of%20protected%20sheets%3C%2FA%3E%2C%2018-Sep-2020%2C%20Windows%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F8946646%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EText%20import%20wizard%20-%20horizontal%20scroll%20is%20not%20working.%3C%2FA%3E%2C%2002-Sep-2020%2C%20Mac%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F41212561%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMoney%20in%20excel%20-%20Add%20Credit%20Karma%20Savings%3C%2FA%3E%2C%2023-Aug-2020%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fadmin%2Fv3%2Fideas%2F40973242%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EEmbedded%20SharePoint%20Online%20Excel%20file%20doesn't%20display%20horizontal%20scrollbar%3C%2FA%3E%2C%2013-Aug-2020%2C%20web%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F10726656%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%22%3EScroll%20horizontally%20by%20pressing%20Ctrl%2BShift%2BWheel%20scroll%3C%2FA%3E%2C%2012-Aug-2020%2C%20Windows%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F13611924%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%22%3EAllow%20PowerQuery%20to%20Extract%20Data%20from%20PDF%20tables%3C%2FA%3E%2C%2010-Aug-2020%2C%20Windows%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F31976935%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%22%3EFiltering%20Needs%20to%20Work%20in%20Co-Authoring%20(Sheet%20Views)%3C%2FA%3E%2C%2031-Jul-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F38552359%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%22%3ETranslate%20XLOOKUP%20and%20XMATCH%20to%20PROCX%20and%20CORRESPX%20in%20Portuguese%3C%2FA%3E%2C%2030-Jul-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F10676208%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%22%3ESelect%20non-adjacent%20cells%20in%20Excel%20for%20the%20web%3C%2FA%3E%2C%2026-Jul-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933%2Fsuggestions%2F10819620%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%22%3EAllow%20for%20personalised%20data%20labels%20in%20XY%20scatter%20plots%20on%20Mac%3C%2FA%3E%2C%2020-Jul-2020%2C%20Mac%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F8192445%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%22%3EAllow%20for%20personal%20user%20views%2Ffilters%20(Sheet%20Views)%3C%2FA%3E%2C%2016-Jul-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F39467770%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%22%3EChart%20design%20and%20formatting%20in%20Excel%20for%20the%20web%3C%2FA%3E%2C%2017-Jun-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F36838606%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%22%3EFormulas%20not%20displayed%20in%20the%20Excel%20interface%20language%3C%2FA%3E%2C%2013-May-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F10733559%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%22%3EIncrease%20the%20218-character%20filename%20length%20limit%20to%20open%20files%20in%20excel%3C%2FA%3E%2C%201-May-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933%2Fsuggestions%2F9603774%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%22%3EJust%20click%20individual%20cells%20to%20sum%20(on%20Mac)%3C%2FA%3E%2C%2014-Apr-2020%2C%20Mac%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F10205019%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOpen%20in%20edit%20mode%20by%20default%20on%20the%20web%3C%2FA%3E%2C%209-Apr-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F17765005%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%22%3EWhen%20a%20document%20is%20locked%20(as%20it's%20being%20edited%20by%20another%20user)%20it%20would%20be%20great%20to%20know%20who%20is%20editing%20the%20file%20offline.%3C%2FA%3E%2C%208-Apr-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F35392672%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%22%3EWhen%20copying%20a%20sheet%20add%20%E2%80%9CYes%20to%20All%E2%80%9D%20option%20for%20name%20conflict%20warnings%3C%2FA%3E%2C%201-Apr-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F12913236%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%22%3ECombine%20RAND%20and%20RANDBETWEEN%3C%2FA%3E%2C%2018-Mar-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F9095341%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%22%3ECreate%20function%20Unique(array)%20extracting%20unique%20values%20from%20an%20array%3C%2FA%3E%2C%2018-Mar-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F15148899%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%22%3EEnable%20user%20to%20pin%20Folders%20to%20the%20recent%20lists%20for%20Open%20and%20Save%20As%3C%2FA%3E%2C%2016-Mar-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F14049132%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%22%3EMake%20a%20simple%20safer%20version%20of%20VLOOKUP%20and%20INDEX%20MATCH%3C%2FA%3E%2C%205-Feb-2020%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933%2Fsuggestions%2F10605018%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%22%3EPrinting%20when%20there%20are%20both%20vertical%20and%20horizontal%20worksheets%3C%2FA%3E%2C%201-Feb-2020%2C%20Mac%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F36891430%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%22%3EImprove%20copy%20%26amp%3B%20paste%20within%20Excel%20for%20the%20web%3C%2FA%3E%2C%2012-Jan-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F36821161%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%22%3EAdd%20%E2%80%9CPaste%20options%E2%80%9D%20to%20right-click%20menu%20in%20Excel%20for%20the%20web%3C%2FA%3E%2C%2011-Jan-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F14912283%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%22%3EAdd%20the%20ability%20to%20create%20Pivot%20Charts%20in%20Excel%20Online%3C%2FA%3E%2C%209-Jan-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F38479465%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%22%3EAdd%20an%20If_NA%20optional%20sixth%20argument%20to%20XLOOKUP%3C%2FA%3E%2C%202-Dec-2019%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933%2Fsuggestions%2F15044469%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%22%3EScrolling%20is%20slow%2Flaggy%20in%20Page%20Layout%20View%20(where%20page%20margins%20are%20shown)%20PLV%3C%2FA%3E%2C%205-Nov-2019%2C%20Mac%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F12515475%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%22%3ERemove%20Duplicates%20for%20Excel%20Online%3C%2FA%3E%2C%2028-Oct-2019%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F11706615%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%22%3EAdding%20advance%20sort%20features%20to%20Excel%20Online%3C%2FA%3E%2C%2028-Oct-2019%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F6828376%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%22%3EOpen%20CSV%20files%20in%20Excel%20for%20the%20web%3C%2FA%3E%2C%2027-Oct-2020%2C%20web%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933%2Fsuggestions%2F33850816%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%22%3EEXCEL%20For%20Mac%20-%20import%20XML%20data%20as%20a%20table%3C%2FA%3E%2C%2023-Oct-2019%2C%20Mac%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F9018823%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%22%3EMake%20Power%20Pivot%20available%20in%20all%20editions%20of%20Excel%20on%20Windows%3C%2FA%3E%2C%2021-Oct-2019%2C%20Windows%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20see%20the%20full%20list%20of%20suggestions%20that%20have%20been%20completed%20by%20clicking%20the%20links%20below%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Ffilters%2Ftop%3Fstatus_id%3D1406092%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%22%3EMac%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304936-excel-for-mobile-devices-tablets-phones-android%2Ffilters%2Ftop%3Fstatus_id%3D1406092%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%22%3EMobile%3C%2FA%3E%20(Android%20%26amp%3B%20iOS)%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Ffilters%2Ftop%3Fstatus_id%3D1406092%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%22%3EWindows%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580-excel-for-the-web%2Ffilters%2Ftop%3Fstatus_id%3D1406092%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%22%3EWeb%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20again%20for%20making%20Excel%20better%20for%20everyone%20through%20your%20feedback%2C%20suggestions%2C%20and%20contributions%20to%20the%20community.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587487%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-1920841%22%20slang%3D%22en-US%22%3ESeries%20de%20datas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920841%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11719%22%20target%3D%22_blank%22%3E%40Steve%20Kraynak%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPe%C3%A7o%20desculpas%20se%20este%20%C3%A9%20o%20local%20incorreto%20para%20postar%20isso%2C%20por%C3%A9m%20eu%20n%C3%A3o%20sei%20utilizar%20este%20site.%3C%2FP%3E%3CP%3ETrabalho%20com%20s%C3%A9ries%20de%20chuvas%2C%20e%20gereu%20uma%20s%C3%A9rie%20de%20datas%20no%20excel%20desde%201900%20at%C3%A9%202020.%20Est%C3%A1%20s%C3%A9rie%20tem%20um%20dia%20de%20deslocamento.%20Descobri%20que%20o%20excel%20trata%20o%20ano%20de%201900%20como%20ano%20bissexto%2C%20entretanto%20este%20ano%20n%C3%A2o%20%C3%A9%20bissexto%2C%20o%20que%20causa%20o%20deslocamento%20na%20s%C3%A9rie.%3C%2FP%3E%3CP%3ECorrigi%20o%20problema%20manualmente%20para%20meus%20estudos%2C%20por%C3%A9m%20este%20tipo%20de%20problema%20pode%20acarretar%20em%20erros%20para%20os%20usu%C3%A1rios%2C%20j%C3%A1%20que%20o%20excel%20%C3%A9%20um%20programa%20utilizado%20por%20cientistas%2C%20contabilistas%20e%20empres%C3%A1rios%20no%20geral.%3C%2FP%3E%3CP%3EUtilizo%20a%20vers%C3%A3o%202010%20do%20Excel%2C%20e%2C%20apesar%20de%20saber%20que%20esta%20vers%C3%A3o%20n%C3%A3o%20recebe%20mais%20suporte%20da%20empresa%2C%20sugiro%20%C3%A0%20Microsoft%20corrigir%20este%20problema%20em%20todas%20as%20vers%C3%B5es%20em%20que%20ele%20apare%C3%A7a%2C%20porque%20se%20trata%20de%20um%20erro%20que%20pode%20ter%20repercuss%C3%B4es%20nos%20trabalhos%20dos%20clientes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAtenciosamente%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERafael%20Silva%20Ara%C3%BAjo%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%5C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20apologize%20if%20this%20is%20the%20wrong%20place%20to%20post%20this%2C%20but%20I%20don't%20know%20how%20to%20use%20this%20site.%3C%2FP%3E%3CP%3EI%20work%20with%20rain%20series%20and%20generated%20a%20series%20of%20dates%20in%20excel%20from%201900%20to%202020.%20This%20series%20is%20shifted%20by%20one%20day.%20I%20discovered%20that%20excel%20treats%201900%20as%20a%20leap%20year%2C%20however%2C%20this%20year%20is%20not%20a%20leap%20year%2C%20which%20causes%20the%20series%20to%20shift.%3C%2FP%3E%3CP%3EI%20corrected%20the%20problem%20manually%20for%20my%20studies%2C%20but%20this%20type%20of%20problem%20can%20cause%20errors%20for%20users%20since%20excel%20is%20a%20program%20used%20by%20scientists%2C%20accountants%2C%20and%20entrepreneurs%20in%20general.%3C%2FP%3E%3CP%3EI%20use%20the%202010%20version%20of%20Excel%2C%20and%20despite%20knowing%20that%20this%20version%20is%20no%20longer%20supported%20by%20the%20company%2C%20I%20suggest%20Microsoft%20correct%20this%20problem%20in%20all%20versions%20where%20it%20appears%20because%20it%20is%20an%20error%20that%20can%20have%20repercussions%20on%20the%20work%20of%20customers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERafael%20Silva%20Ara%C3%BAjo%3C%2FP%3E%3CPRE%3E%26nbsp%3B%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920916%22%20slang%3D%22en-US%22%3ERe%3A%20Series%20de%20datas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920916%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877369%22%20target%3D%22_blank%22%3E%40Rafael_Araujo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20probably%20this%20never%20will%20be%20corrected%2C%20please%20see%20details%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Ftroubleshoot%2Fexcel%2Fwrongly-assumes-1900-is-leap-year%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20incorrectly%20assumes%20that%20the%20year%201900%20is%20a%20leap%20year%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1920974%22%20slang%3D%22en-US%22%3ERe%3A%20Series%20de%20datas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1920974%22%20slang%3D%22en-US%22%3E%3CP%3EOh%20really%3F%3C%2FP%3E%3CP%3EI%20can%20understand%20the%20disadvantages%20of%20correcting%20the%20error%2C%20but%20Excel%20creates%20the%20list%20with%20no%20error%20message%20despite%20the%20error%20being%20known%20by%20the%20company.%20This%20is%20unprofessional%20in%20my%20understanding.%3C%2FP%3E%3CP%3EPeople%20rely%20on%20this%20software%20to%20work%20and%20automate%20tedious%20activities%2C%20such%20as%20building%20a%20date%20list.%20If%20errors%20will%20be%20admitted%20in%20the%20software%2C%20they%20should%20be%20made%20clear%20to%20the%20user%2C%20for%20example%20with%20an%20error%20flag%2C%20to%20be%20manually%20corrected.%3C%2FP%3E%3CP%3EIf%20I%20trusted%20the%20software%20I%20would%20have%20propagated%20an%20error%20through%20all%20my%20data%2C%20this%20is%20not%20a%20negligible%20thing.%3C%2FP%3E%3CP%3EIt%20makes%20one%20wonder%20what%20other%20types%20of%20errors%20can%20be%20happening%20and%20are%20not%20displayed%20clearly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921039%22%20slang%3D%22en-US%22%3ERe%3A%20Series%20de%20datas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921039%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877369%22%20target%3D%22_blank%22%3E%40Rafael_Araujo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELeap%20year%20issue%20is%20known%20for%20ages%20it%20continue%20to%20exist%20mainly%20due%20to%20compatibility.%20First%20with%20Lotus%201-2-3%2C%20now%20with%20all%20previous%20generations%20of%20Excel.%20To%20fix%20it%20now%20and%20break%20worksheets%20with%20different%20kind%20of%20workarounds%20which%20use%20millions%20of%20users%20-%20I%20don't%20think%20that's%20unprofessional.%20At%20least%20that's%20discussable.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOn%20Mac%20dates%20start%20from%201904%2C%20on%20Windows%20you%20also%20have%20such%20option.%20We%20don't%20consider%20as%20a%20bug%20that%20Excel%20doesn't%20work%20with%20dates%20before%201900%20if%20except%20VBA%2C%20Power%20Query%20and%20different%20tricks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921173%22%20slang%3D%22en-US%22%3ERe%3A%20Series%20de%20datas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20think%20you%20misunderstood%20me.%20I%20didn't%20say%20that%20leaving%20this%20error%20in%20the%20program%20is%20unprofessional.%20I%20understand%20the%20reason%20the%20issue%20was%20not%20fixed%20by%20reading%20the%20link%20you%20sent%20me.%3C%2FP%3E%3CP%3EI%20was%20referring%20to%20the%20fact%20that%20the%20error%20was%20not%20flagged.%20I%20think%20it%20is%20not%20reasonable%20to%20assume%20the%20user%20is%20aware%20of%20an%20error%20without%20informing%20him.%20Even%20if%20it%20is%20a%20widely%20known%20error%2C%20because%20not%20every%20user%20is%20a%20specialist.%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20simply%20generating%20a%20list%20with%20an%20error%20with%20no%20warning%20to%20the%20user%2C%20couldn't%20the%20incorrect%20cell%20be%20shown%20in%20red%2C%20for%20example%2C%20with%20a%20link%20to%20that%20explanation%20you%20sent%20me%3F%20That%20would%20have%20been%20sufficient%20for%20me%20and%20would%20have%20saved%20me%20some%20time%20searching%20for%20the%20reason%20for%20the%20series%20shifting.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENevertheless%2C%20my%20intention%20was%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Esolely%20to%20inform%20one%20issue%20I%20found.%20I%20am%20just%20an%20occasional%20user.%20I%20understand%20now%20that%20the%20error%20is%20already%20known%20to%20many.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ERafael%20Silva%20Ara%C3%BAjo%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Hi - 

Thank you for sharing your ideas and suggestions on Excel.uservoice.com! Your continued input and feedback help make Microsoft Excel better every day. 

 

The list below shows how you’ve helped improve Excel – click on the title to learn more about each item. We'll continue adding to this list. Subscribe to this post to get the latest update.

 

 

You can see the full list of suggestions that have been completed by clicking the links below:

 

Mac

Mobile (Android & iOS)

Windows

Web

 

Thanks again for making Excel better for everyone through your feedback, suggestions, and contributions to the community.

 

12 Replies

@Steve Kraynak , thanks for sharing. By the way, I guess this one Pull Current Stock Prices and Historical Data Into Excel also could be closed, it's still in Started status from Dec 2018.

Thanks for the update, @Steve Kraynak. Is good to see this changelog associated with UserVoice, so we can see better the dimension of that channel on the improvements. Do you have some information about these 2 suggestions below?

 

 

Thank you!

@Steve Kraynak 

Hi Steve,

Nice post. Does the Excel team incorporate the Excel.UserVoice.com into its Road-Map for excel?
There are currently 6 product suggestions in the top 10 that have a status of "accepting votes".

Some of these suggestions in the top 10 have been open since 2015 to no success.

As you have indicated in your previous post the site doesn't currently capture what has been taken into consideration. Might I suggest that your team implement a similar approach to the experience.dynamics.com product suggestions.

Where by each suggestion is tagged with a status of "Completed", "In Review", "Needs Votes".
This would then assist your team in focusing on some of the higher voted items, and would also provide more visibility to users.

It would also provide the visibility that you described of features your team has completed suggestions that "make excel better".

Bleddyn_James_1-1597789948043.png

 


Are you able to shed any light on when the Conditional Formatting applied to named ranges is likely to be incorporated into future versions?
It would be great to understand where this is in the Excel teams Road-Map as it is one of the most voted items, has been open since 2015 and still has a status of "Accepting Votes".

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10561194...


I look forward to hearing from you.

Cheers
Bleddyn

I need help with a formula can someone advise me? I am not sure even on the function to use?

@Jenny895 

Better if you ask the question here https://gorovian.000webhostapp.com/?exam=t5/excel/ct-p/Excel_Cat using Start New Conversation button.

Best Response confirmed by cuong (Microsoft)
Solution

@Jenny895 

The best way to get help is to post your question in the Excel area, explaining the problem you need to solve. If you can provide an example, it will be easier for anyone who jumps in to try to help you.

Post your question here:

https://gorovian.000webhostapp.com/?exam=t5/excel/bd-p/ExcelGeneral

@Steve Kraynak 

Are you able to shed some light on what "not at this time" means?

https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10561194...
Bleddyn_James_0-1599687510364.png

This has been a product suggestion for almost 5 YEARS!
If "not at this time" when?

 

It is one of the most voted items not only in its category but across the excel suggestions.

 

Responding by saying "it's in the too hard basket" is not a valid response.

Please provide an ETA/road map of when you actually intend to resolve this product suggestion!

There is absolutely no point in users using the voting system of forum if they are simply going to be ignored.

 

Thanks
Bleddyn

@Steve Kraynak 

Peço desculpas se este é o local incorreto para postar isso, porém eu não sei utilizar este site.

Trabalho com séries de chuvas, e gereu uma série de datas no excel desde 1900 até 2020. Está série tem um dia de deslocamento. Descobri que o excel trata o ano de 1900 como ano bissexto, entretanto este ano nâo é bissexto, o que causa o deslocamento na série.

Corrigi o problema manualmente para meus estudos, porém este tipo de problema pode acarretar em erros para os usuários, já que o excel é um programa utilizado por cientistas, contabilistas e empresários no geral.

Utilizo a versão 2010 do Excel, e, apesar de saber que esta versão não recebe mais suporte da empresa, sugiro à Microsoft corrigir este problema em todas as versões em que ele apareça, porque se trata de um erro que pode ter repercussôes nos trabalhos dos clientes.

 

Atenciosamente,

 

Rafael Silva Araújo

 

 

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

 

I apologize if this is the wrong place to post this, but I don't know how to use this site.

I work with rain series and generated a series of dates in excel from 1900 to 2020. This series is shifted by one day. I discovered that excel treats 1900 as a leap year, however, this year is not a leap year, which causes the series to shift.

I corrected the problem manually for my studies, but this type of problem can cause errors for users since excel is a program used by scientists, accountants, and entrepreneurs in general.

I use the 2010 version of Excel, and despite knowing that this version is no longer supported by the company, I suggest Microsoft correct this problem in all versions where it appears because it is an error that can have repercussions on the work of customers.

 

Regards,

 

Rafael Silva Araújo

 

 

@Rafael_Araujo 

Most probably this never will be corrected, please see details here Excel incorrectly assumes that the year 1900 is a leap year 

Oh really?

I can understand the disadvantages of correcting the error, but Excel creates the list with no error message despite the error being known by the company. This is unprofessional in my understanding.

People rely on this software to work and automate tedious activities, such as building a date list. If errors will be admitted in the software, they should be made clear to the user, for example with an error flag, to be manually corrected.

If I trusted the software I would have propagated an error through all my data, this is not a negligible thing.

It makes one wonder what other types of errors can be happening and are not displayed clearly.

 

 

@Rafael_Araujo 

Leap year issue is known for ages it continue to exist mainly due to compatibility. First with Lotus 1-2-3, now with all previous generations of Excel. To fix it now and break worksheets with different kind of workarounds which use millions of users - I don't think that's unprofessional. At least that's discussable. 

 

On Mac dates start from 1904, on Windows you also have such option. We don't consider as a bug that Excel doesn't work with dates before 1900 if except VBA, Power Query and different tricks.

@Sergei Baklan I think you misunderstood me. I didn't say that leaving this error in the program is unprofessional. I understand the reason the issue was not fixed by reading the link you sent me.

I was referring to the fact that the error was not flagged. I think it is not reasonable to assume the user is aware of an error without informing him. Even if it is a widely known error, because not every user is a specialist. 

Instead of simply generating a list with an error with no warning to the user, couldn't the incorrect cell be shown in red, for example, with a link to that explanation you sent me? That would have been sufficient for me and would have saved me some time searching for the reason for the series shifting. 

Nevertheless, my intention was solely to inform one issue I found. I am just an occasional user. I understand now that the error is already known to many.

Regards,

Rafael Silva Araújo

www.000webhost.com