I have colleagues who have 20 copies of the same document with slight variations named like this in a folder. I honestly don’t understand how they function at work.
Every tech noob user I see. Worse if it’s mac because 1) I cannot use it for the life of me and 2) almost every Mac user stores it in the same default downloads folder and won’t know what path it’s in unless they use the Finder tool.
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.
It will live in a folder with:
Spreadsheet(1).xls Spreadsheet - shortcut.lnk Spreadsheet(2) - Copy.xls New Spreadsheet - DO NOT USE.xls
I have colleagues who have 20 copies of the same document with slight variations named like this in a folder. I honestly don’t understand how they function at work.
Sort by last modified
Could be they don’t.
Every tech noob user I see. Worse if it’s mac because 1) I cannot use it for the life of me and 2) almost every Mac user stores it in the same default downloads folder and won’t know what path it’s in unless they use the Finder tool.
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.
Almost 24 hours and no one has commented on MMDDYY? I don’t know whether to be proud or disappointed.
As an European I just sigh and read on.
Could just use git…
using git on a bunch of XML files saved into a binary ZIP file with a
.xlsxfilename extension is a hell whose circle we have not yet discoveredThat’s just version control but worse!