Comment

Comment on it always interesting when multi billion dollar company's costing system is a 63 tab excel 97 spreadsheet at it's core...

<- View Parent

droans@lemmy.world ⁨11⁩ ⁨months⁩ ago

I work in Finance at my company and we always save revised copies for Excel files instead of saving over.

But we also have strict rules on it. File name is always “xxxx_Workbook Template Name_MMDDYY.xlsx” or “_YYYY_MM.xlsx”, depending on how often it gets updated.

Older versions get moved to a subfolder. It helps us go back and find out what something was if there was a mistake or revert back if Excel done fucks up.

source

Sort:hotnew top

timbuck2themoon@sh.itjust.works ⁨11⁩ ⁨months⁩ ago
Could just use git…

source
- lars@lemmy.sdf.org ⁨11⁩ ⁨months⁩ ago
  using git on a bunch of XML files saved into a binary ZIP file with a .xlsx filename extension is a hell whose circle we have not yet discovered
  
  source
gazter@aussie.zone ⁨11⁩ ⁨months⁩ ago
Almost 24 hours and no one has commented on MMDDYY? I don’t know whether to be proud or disappointed.

source
- WhiteHotaru@feddit.de ⁨11⁩ ⁨months⁩ ago
  As an European I just sigh and read on.
  
  source
Matriks404@lemmy.world ⁨11⁩ ⁨months⁩ ago
Do people in your company know that there’s something called Windows File History?

source
- Blue_Morpho@lemmy.world ⁨11⁩ ⁨months⁩ ago
  It never works when you need it. Like “that file was too big”, that file was on a network share, that file is outside the window of how many old changes are saved. It’s like using an undelete utility. Sometimes you get lucky.
  
  It’s better to save every change as a dated/numbered file or use a real source control system.
  
  source
blackbirdbiryani@lemmy.world ⁨11⁩ ⁨months⁩ ago
Honestly this is one I the reasons why I love Google sheets (controversial I know) as it has a built in version control system.

source
- freebee@sh.itjust.works ⁨11⁩ ⁨months⁩ ago
  Excel has it too if you store it in onedrive or a sharepoint library with versioning enabled
  
  source