Excel and SharePoint together as a non-US person is hot garbage
Our take
The frustrations expressed in the recent Reddit post about Excel and SharePoint highlight a significant challenge that many users face in today’s evolving digital workspace. As the user notes, a simple file sent for collaboration led to unexpected complications with date formats and function usability. This experience raises broader questions about how technology—specifically tools like Excel and SharePoint—is adapting to the diverse needs of a global user base. Are these legacy tools becoming less user-friendly in an increasingly interconnected world? The sentiment echoes discussions surrounding usability, as seen in articles like What is the most elegant way of returning 0 when Div/0 without masking all other errors too? and I made an offline Excel cleaning tool for Android, which delve into specific issues and adaptations users are making to navigate Excel’s complexities.
The crux of the problem lies not only in the technical limitations but also in the configuration and contextual usage of these tools. The user’s frustration reflects a moment of regression, where what was once a seamless experience has become a source of annoyance. This poses a critical question for organizations: are we configuring our tools in a way that caters to our diverse workforce, or are we inadvertently creating barriers? Configuration issues can certainly exacerbate user experience, but they also point to a larger trend in how cloud-based tools are evolving. As organizations shift toward collaborative, cloud-native solutions, they must also consider the varying needs of users across different regions and cultures.
Moreover, this incident raises awareness about the broader implications of relying on a single tool for complex tasks. With the rise of AI and machine learning technologies, the landscape of data management is rapidly changing. Users are seeking more innovative solutions that not only simplify workflows but also enhance productivity. As noted in the Reddit commentary, what was once a straightforward task has turned into a cumbersome process, signaling a need for more intuitive, adaptable software solutions. This context is crucial as we consider the future of data management tools and their ability to meet the evolving demands of users.
As we look to the future, it is essential to recognize that the integration of advanced technologies must go hand in hand with user-centric design. The frustration experienced by the Reddit poster is not isolated; it reflects a shared concern among users navigating increasingly complex digital environments. Companies like Microsoft must prioritize user feedback and continuously iterate on their products to ensure they remain relevant and functional in diverse contexts. The question remains: will legacy tools adapt to meet the needs of a global user base, or will they falter as new, more adaptable solutions emerge?
Ultimately, the conversation around tools like Excel and SharePoint serves as a reminder that technology must evolve to empower users rather than hinder them. As we venture into a future where data management becomes increasingly sophisticated, the call for accessible and innovative solutions will only grow louder. The implications of these developments warrant close attention, as they will shape the way we work and collaborate in the years to come.
A co worker sent me a file to do some work on over teams and SharePoint. The dates which can be interpreted as US dates were automatically converted. And the datedif function won't work unless they're in US format?
This is stuff I was doing years ago with zero frustration and it's an absolute pain now. Is this a configuration issue my employer has made or is Excel a basket case since office365?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- US dates entered suddenly being interpreted as European datesI have a worksheet I use to calculate my volunteer mileage for tax purposes, copying it each year to a new version for the current year. I enter in the date in the first column (mm/dd/yy) and it displays in my desired format (mm-dd-yyyy). Worked great for years... until today. I cleared out the data and started entering in dates, and I noticed some of the dates were changing to the correct format and others were staying in the entered format. Upon further investigation, I realized the entered dates were being interpreted as European dates (dd/mm/yy). I changed the formatting for the column to mmm-dd-yyyy and saw this plainly. I confirmed that the Windows regional attributes were correctly set for the US, including the date formats. (I've never touch this, but I wanted to be sure.) I went back and recopied the original worksheet to the new year's version, and I noticed all of the dates in both the old year's and new were now being shown in the dd-mm-yyyy format. When I entered in 1/6/25, and it displayed as Jun-01-2025. What the heck? I am baffled as to why this is suddenly happening for a worksheet that has been performing perfectly fine for several years. Thoughts? submitted by /u/melrowgo [link] [comments]
- Unify excel date format for all usersAt work we have a file, that used to be set up in a way, where no matter what date format you use (dd.mm.yy ; mm.dd.yy ; d.m.yy ; m.d.yy ; dd/mm/yyyy ; dd/mm/yy ; ...) it would always visually adjust to the current users system settings and always read the input as date. So if one coworker used and typed dd/mm/yyyy, he would see all dates in the table like that. While I use dd.mm.yy and I would see all date like that. I hope the explanation makes sense... this stopped working last year, and I tried what internet suggested: Changing the user settings in OS to a format they use. Changing it to a adjustable format so everyone has their own format and now it is all set to a firm format (dd.mm.yy) so it displays the same for everyone and it doesn’t matter if they type it with slashes (dd/mm/yy ; dd/mm/yyyy) but if someone types specifically in dd.mm.yyyy format it doesnt recognize it as a date anymore... I feel insane at this point! submitted by /u/Expert_Plankton_7561 [link] [comments]