How to speed up an Excel file?

Question

Database

In the accounting department there is a traditional Excel monster file weighing under 100MB and barely moving on the server. There are two problems: speed and safety.
How can they be solved? Connect SQL? Convert to binary and forget?
So I didn't see an answer. The file is accounting, there are no whistleblowers, it just arrived and went away in a few years. All lamer problems have been fixed, only the i9 and RAID 0 option remains.
The question is simple, if "try something more different", then what? access? SQL?

Answer 1

Often the problem with the size of Excel files is the given style to an infinite range of cells. It is worth checking for a huge number of empty cells and clearing their styles and contents.
Can be split into different files.
It is possible to transfer with blood and then in Access.
If none of the solutions satisfies users, you can offer them a universal solution - "put it down".

Answer 2

1. use something more different
2. try save as
3. figure out the structure and remake it to a more optimal one