How to speed up Excel file?

In accounting there is traditional montravail Excel weight under 100Mb and barely which manipulates it on the server. The problems are two: speed and safety.
How can they be addressed? To connect SQL? Transfer in binary and forget?

Never saw answer. File accounting, there is no sustainiac, just arrived departed in a few years. All lamerskie fixed problems, leaving only the option of RAID 0 and i9.
The question ' s simple, if the "try something a bit more casual", then what? Access? SQL?
June 14th 19 at 20:39
2 answers
June 14th 19 at 20:41
Often, the problem size of Excel files - the specified style to the infinite range of cells. It's better to check a huge number of empty cells and clear their styles and content.
Can be split into different files.
You can transfer to blood and then to Access.

If none of the solutions will not satisfy the users, it is possible to offer a universal solution - "humble".
We somehow Excel malfunctions and he began to count empty rows and columns are non-empty. The file size has grown to 20Mb+, any operation led to wild brakes. Found in the network a simple solution to "clean" the empty cells do not help, I had to migrate the data by hand into a new file, all ran.

If much data is to divide the file into several, for example, the date data (in an old archive file and the current year leave to work), or to transfer to the database. - Adrienne81 commented on June 14th 19 at 20:44
I will add my two cents: if you are using exely share, the file swells from the history log and other debris. Need from time to time to remove sharing to resave the file, then shared again to exhibit.
In addition in shared mode all the typical problems described above are multiplied by the number of concurrent users.
In my experience - if you work to Excel in the public domain, it is better now to start looking for another alternative - any database would be better than Axel (or single-user version of the work). Sooner or later the problem will grow to such proportions that to fight them will have to continuously. - Lucio commented on June 14th 19 at 20:47
June 14th 19 at 20:43
1. to use something else
2. try to save as
3. to understand the structure and to convert to a more optimal

Find more questions by tags ExcelDatabasesSQL Server