Clowns to the left of me. Jokers to the right.

Here I am, stuck in the middle with you.

  • 0 Posts
  • 17 Comments
Joined 2 months ago
cake
Cake day: January 7th, 2025

help-circle

  • The data that needs to be fixed changes locations on the spreadsheet monthly. It’s never the same two months in a row

    Look I appreciate your trying to help, but after 3 months of calls and emails back and forth with several people at Microsoft as well as our company’s 3rd party IT guys (I’m the in house IT guy) we have just determined that the only way to get it done is to have me spend a couple hours once a month un fucking the data that excel chewed up.

    It is what it is.



  • The program generates a report for us once a month. It can be generated as an excel file or as another file type which we cannot use. When it generates the excel file it breaks a bunch of numbers that are used often and all throughout our data as excel thinks they are dates. When we try and reverse any of those numbers in all the many ways people have recommended the data never goes back all correctly. So I have to manually replace the data cell by cell afterwards.

    We are unable to preemptively format any settings in excel to prevent this from happening.

    There once was a beta version of excel that had the exact feature we need (excel leaves all data untouched unless told otherwise), but for some godforsaken reason Microsoft got rid of that setting.


  • I have had an untold number of coders and Microsoft experts look at this problem. There is nothing that can be done.

    Program 1 cannot be changed as the job requires it and it will only automatically spit out into excel. Excel immediately breaks several numbers across the spreadsheet by turning them into dates. Nobody at Microsoft can get the sheets to revert back into the original data correctly. Nothing can be done to preemptively format excel not to fuck the dates.



  • Microsoft.

    And it’s almost entirely because of excel.

    We have a program that automatically outputs an excel document every month. I then have to go into this document and unfuck all the data that excel decided to turn into dates. There is no way to format the file before the program spits out the excel doc. There is now way to reverse the change and have it go back to the original data correctly.

    I have spent countless hours on the phone with Microsoft support and digging around forums trying to make it stop breaking our data, but I have been told by multiple Microsoft support employees that it is impossible.

    I did find out that there used to be a beta version of excel back in like 2017 where you could change a setting that forced your excel to leave all day alone until told to do something with it, but they never finished it and it was eventually removed as a setting.

    WHY WOULD YOU TAKE AWAY THAT ABILITY MICROSOFT. WHY.










  • I got into psych (TV show) because of an ex and eventually I convinced my father to watch it. Well now he quotes it all the time. The one that comes up almost daily is “I’ve heard it both ways” after one of us pronounces something wrong or someone else pronounces something wrong.

    Goofy fun show. You gotta just enjoy the goofiness and not think too much. Luckily it has tons of themed episodes and endless references to other Pop culture moments. The writing is snappy and honestly you miss a lot of jokes the first time around because half of them are said under someone’s breath or by someone slightly off screen and outta focus.