SOLVED

How your ideas 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%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%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%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%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%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%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-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%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%3CLINGO-SUB%20id%3D%22lingo-sub-2195191%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-2195191%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%3Bare%20you%20and%20Microsoft%20choosing%20to%20ignore%20my%20previous%20post%20and%20the%20product%20suggestion%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2203516%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-2203516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F692525%22%20target%3D%22_blank%22%3E%40Bleddyn_James%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20choosing%20to%20ignore.%20We%20have%20commented%20that%20we%20will%20not%20be%20addressing%20this%20at%20this%20time.%20To%20give%20a%20bit%20more%20detail%20about%20the%20complexity%2C%20compatibility%20with%20older%20versions%20of%20Excel%20is%20a%20big%20consideration%20here.%20Older%20versions%20would%20still%20only%20be%20compatible%20with%20having%20a%20fixed%20range%20in%20the%20Applies%20To%20field%2C%20so%20the%20Applies%20To%20range%20would%20need%20to%20be%20saved%20in%20the%20file%20in%20such%20a%20way%20that%20both%20old%20and%20new%20versions%20could%20deal%20with%20it%20properly.%20If%20someone%20with%20an%20older%20version%20saved%20the%20file%2C%20it%20could%20mean%20that%20the%20CF%20rule%20would%20be%20switched%20to%20the%20fixed%20range.%20Then%20if%20someone%20with%20the%20newer%20version%20opened%20the%20file%2C%20they%20may%20not%20understand%20what%20happened%20to%20the%20CF%20rule.%20Also%2C%20there%20can%20be%20Names%20that%20are%20dynamic%2C%20such%20as%20%3DOFFSET(Sheet1!%24A%241%2C0%2C0%2CSheet1!%24B%241%2C1).%20If%20such%20a%20Name%20was%20used%20in%20the%20Applies%20To%20field%2C%20then%20the%20conditional%20formatting%20rule%20may%20need%20to%20be%20adjusted%20when%20the%20workbook%20is%20calculated.%20Depending%20on%20the%20complexity%20of%20the%20formula%20in%20the%20Name%2C%20this%20could%20have%20performance%20implications%20and%20there%20are%20many%20different%20cases%20that%20need%20to%20be%20considered%20and%20handled%20properly.%3C%2FP%3E%0A%3CP%3EComplexity%2C%20risk%20of%20affecting%20expected%20behavior%2C%20and%20how%20older%20versions%20of%20Excel%20will%20deal%20with%20a%20change%20are%20important%20factors%20that%20we%20consider%20when%20making%20plans%20for%20upcoming%20engineering%20work%2C%20in%20addition%20to%20feedback%20and%20votes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2203733%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-2203733%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%3EThanks%20for%20the%20response.%3CBR%20%2F%3EDo%20you%20believe%205%20years%20(almost%206%20years)%20is%20a%20reasonable%20time%20for%20one%20of%20the%20most%20voted%20items%20to%20not%20be%20resolved%20%2F%20addressed.%3CBR%20%2F%3E%3CBR%20%2F%3EDon't%20get%20me%20wrong%20I%20appreciate%20there%20are%20likely%20many%20complexities.%20But%205%20years%20is%20ridiculous%20to%20address%20the%20communities%20top%20suggestions%20%2F%20pain%20points.%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%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F10561194-conditional-formatting-apply-to-named-ranges%3C%2FA%3E%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%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%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921-excel-for-windows-desktop-application%2Fsuggestions%2F31677361-unhide-multiple-worksheets-at-once%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EUnhide%20Multiple%20Sheets%20at%20once%3C%2FA%3E%2C%2023-Mar-2021%20-%20read%20more%20here%20%26gt%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Funhide-multiple-worksheets%2Fba-p%2F2234073%22%20target%3D%22_blank%22%3EUnhide%20multiple%20worksheets%3C%2FA%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20class%3D%22evt-forum-suggestions-suggestion-link%22%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F16092793%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EThe%20Conditional%20Formatting%20Rules%20Manager%20badly%20needs%20the%20ability%20to%20be%20resized%2C%3C%2FSPAN%3E%3C%2FA%3E%26nbsp%3B2-Mar-2021%20-%20read%20more%20here%20%26gt%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fresizable-conditional-formatting-dialogs%2Fba-p%2F2180229%22%20target%3D%22_self%22%3EResizable%20Conditional%20Formatting%20dialogs%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F32606854%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAllow%20the%20time%20and%20date%20to%20be%20corrected%20or%20the%20time%20zone%20to%20be%20adjusted%20in%20Excel%20Online%3C%2FA%3E%2C%2023-Feb-2021%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F274580%2Fsuggestions%2F10526343%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EIn%20Excel%20for%20the%20web%2C%20highlight%20cells%20affected%20by%20formula%20when%20editing%3C%2FA%3E%2C%208-Feb-2021%3C%2FLI%3E%0A%3CLI%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304921%2Fsuggestions%2F32223604%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPull%20Current%20Stock%20Prices%20and%20Historical%20Data%20Into%20Excel%3C%2FA%3E%2C%2001-Feb-2021%20-%20read%20more%20here%20%26gt%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-stockhistory%2Fba-p%2F1404338%22%20target%3D%22_blank%22%3EAnnouncing%20STOCKHISTORY%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%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%2F40687084%22%20target%3D%22_blank%22%20rel%3D%22noopener%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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%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
Microsoft

Hi - 

Thank you for sharing your ideas and suggestions! 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.

 

15 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://techcommunity.microsoft.com/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://techcommunity.microsoft.com/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

@Steve Kraynak are you and Microsoft choosing to ignore my previous post and the product suggestion?

@Bleddyn_James 

Not choosing to ignore. We have commented that we will not be addressing this at this time. To give a bit more detail about the complexity, compatibility with older versions of Excel is a big consideration here. Older versions would still only be compatible with having a fixed range in the Applies To field, so the Applies To range would need to be saved in the file in such a way that both old and new versions could deal with it properly. If someone with an older version saved the file, it could mean that the CF rule would be switched to the fixed range. Then if someone with the newer version opened the file, they may not understand what happened to the CF rule. Also, there can be Names that are dynamic, such as =OFFSET(Sheet1!$A$1,0,0,Sheet1!$B$1,1). If such a Name was used in the Applies To field, then the conditional formatting rule may need to be adjusted when the workbook is calculated. Depending on the complexity of the formula in the Name, this could have performance implications and there are many different cases that need to be considered and handled properly.

Complexity, risk of affecting expected behavior, and how older versions of Excel will deal with a change are important factors that we consider when making plans for upcoming engineering work, in addition to feedback and votes.

@Steve Kraynak 

Thanks for the response.
Do you believe 5 years (almost 6 years) is a reasonable time for one of the most voted items to not be resolved / addressed.

Don't get me wrong I appreciate there are likely many complexities. But 5 years is ridiculous to address the communities top suggestions / pain points.

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