3 ms·
Oh you must have seen my accounting department's 'transaction register' which is a... checks latest 64mb spreadsheet that amounts to one gigantic, ever slower
by Arrath 4y ago
Oh you must have seen my accounting department's 'transaction register' which is a...
checks latest
64mb spreadsheet that amounts to one gigantic, ever slower pivot table.
- Optimal_Persona 4y agoOne department at my agency shrunk an ~80MB Excel sheet down to ~1-2MB by using the .xlsb (Excel Binary) file format, and it sped up quite a bit. But point taken, once this is the single source of truth for biz-critical data, Excel is not the right storage format.