Chapter 21 · 21.12
A very large file that won't open or won't save
A spreadsheet with tens of thousands of rows from your till system, an annual report with a hundred photos, a presentation with video clips. With very large files, Euro-Office in the browser can show two messages. In this article you'll learn what they mean, how to make the file smaller and when to contact support.
The messages
| Message | When |
|---|---|
| The file size exceeds the limitation set for your server. followed by a sentence asking you to contact your administrator | When opening: the file is too large to edit in the browser. |
| The size of actions exceeds the limitation set for your server. | While working: you changed a lot in one go, for example by pasting tens of thousands of cells. |
Both limits protect the server, so that one huge file doesn't slow Euro-Office down for everyone. The exact limits are a server setting; you can't change them yourself.
Why the size in Nextcloud is misleading
An xlsx, docx or pptx file is actually a packed (compressed) file. A 30 MB spreadsheet in your Nextcloud can be many times larger once unpacked, and Euro-Office has to unpack the whole file to display it. That's why a file that doesn't look all that big in your Nextcloud can still be too large to open.
Making the file smaller
Example: the sales export from Bakkerij De Korenaar with every receipt from five years. First check what makes the file so large:
- Empty, formatted rows and columns. If someone once gave a whole column a colour or extended it down to row 1,000,000, the file counts all those cells. Select the rows below your last data, right-click and choose Delete; do the same for the columns to the right of your data.
- Images. Photos straight from a phone are often several MB each. Resize them before you insert them.
- Old or hidden worksheets that nobody uses any more.
- Everything in one file. Split it by year: Verkoop 2025, Verkoop 2026. You can then create an overview with a link to the yearly files (see Linking cells to another spreadsheet in your Nextcloud) or with a pivot table per year.
- Video in a presentation. Put the video in your Nextcloud as a file and add a link to it on the slide.
Does the file not open at all?
Then you can't make it smaller in the browser either. Here's what to do:
- Open the file in the Nextcloud Office program on your computer (see Euro-Office as a program on your computer: what is it and when do you use it?) or in another office program on your computer.
- Make it smaller as described above and save it under a new name.
- Put the smaller version back in your WebOké Nextcloud and open it in the browser.
Message while working
If you get the message about the size of actions, choose Undo. Your last action is reversed and the document stays intact. If you choose Continue, the message says Euro-Office only saves the action locally, in your browser: download the file straight away, otherwise you may lose your work. After that, make large edits in smaller chunks, for example by pasting 5,000 rows at a time.
When should you contact support?
Can't make the file smaller, or does it really need to be this large? Then contact WebOké support (see When you contact support). Include the file name, the size in your Nextcloud and the message you get. Support will help you find the best solution.
Pitfalls
- Formulas longer than 8,192 characters: Euro-Office removes such a formula when opening the file and tells you so. Split a very long formula across helper cells.
- Large and slow is not the same as too large. If the file does open but responds slowly, read Speed up a slow spreadsheet.
- Synchronisation: a very large file that you also sync via the desktop app can be locked while it's being saved. See Saving or syncing isn't working.
