If you've received a message about calculations being disabled due to doc size, learn how to resolve the issue here.
If your doc becomes so large that calculations are no longer performant, this may result in formulas, calculations, and other elements being temporarily disabled. As your doc approaches this formula calculation limit, you will receive warnings within the doc. Once the limit is exceeded, you will see a message in your doc that states "doc is too large” or "doc size limit exceeded." If this is happening to you, then continue reading. This article will explain the formula calculation limit and how you can get calculations re-enabled.
Within this article, you’ll find...
Why are calculations disabled in my doc?
All docs - regardless of plan type - are subject to a formula calculation limit of 325 MB. Once a doc exceeds this limit, calculations are no longer performant. Therefore, formulas, calculations, sync tables, automations, and other doc elements will be temporarily disabled until the doc is sufficiently reduced in size.
So why does doc size matter, and how does that relate to calculations? When you access a Coda doc, the full doc is downloaded into your browser cache so that you can work in it even without an internet connection. But the bigger the doc size, the tougher it is for your browser to run it. If the doc grows big enough, it may become too big for your browser to load at all. This is why calculations might be turned off.
Therefore, if calculations have been disabled, the solution is to reduce the size of the doc back down below the size limits. Once the doc is scaled back sufficiently, calculations and other paused elements will be automatically re-enabled. Check out the following section for instructions on how to do this.
Re-enable calculations
In order to automatically re-enable calculations, you must first solve the issue that caused the calculations to be disabled initially. In other words, you will need to reduce the size of your doc to below the 325 MB formula calculation limit.
Exactly how you downsize your doc will depend on the content of your doc and your specific needs. Often times, removing unnecessary rows, high-volume columns, or tables/views will be the key to downsizing your doc.
You can learn all about managing doc size, including how to start downsizing, in this comprehensive article.
When you see the Doc size limit exceeded message in the upper-right corner of your doc, you can click on the Review options button to investigate. This will take you to the Statistics section of your doc settings, where you will see information about how far over the 325 MB limit the doc currently is. This should give you a sense of how much data you need to remove. Note that you can also access this statistics panel by clicking the three-dot menu in the upper right of your doc, selecting Doc settings, then selecting Statistics.
As you downsize your doc by archiving and deleting stale data, the doc will automatically attempt to re-enable calculations. If you've deleted enough data to bring your doc below the limit, the calculations will be successfully re-enabled. If you haven't deleted enough data, you'll see a message suggesting that you delete even more data.
The Doc Size section of the statistics panel will reflect the deleted data and give you a sense of how much more space you need to free up. Continue the process of deleting data until calculations are successfully re-enabled.
Please note that it can sometimes take up to 12 hours after deleting content for the doc size statistics to update accurately.
FAQs
What does the formula calculation limit mean? What are the implications?
Once a doc exceeds the 325 MB formula calculation limit, data can still be deleted or added, and other content edits can still be made. But the results of formulas will not be calculated, automations will not run, and any Pack sync tables (including Cross-doc syncs) will be paused. For instance, if a formula is changed for a column, the values in that column will not be updated to the new results until calculations are turned back on.
If I delete things from my doc with calculations disabled, will those deletions actually happen?
Yes, you can downsize your doc by deleting old rows or unused columns, and you can even remove things like conditional formatting. These deletions will all take place and help to downsize the doc to a level where calculations can be re-enabled.
Will I receive warnings as my doc is approaching the calculation limit?
Yes - we will be sure to send you multiple notifications (both in-doc and via email) as your doc gets closer and closer to the calculation limit. When your doc is 75% of the way to the limit, you will see a warning within the Statistics panel of your doc. When your doc is about 80% to the limit, you will also see a “Doc is getting too large” in-doc notification in the upper-right corner of your doc. And once your doc has hit 100%, you will see an in-doc message stating “doc size limit exceeded.”
Are there any other doc limits I should be aware of?
Yes, there are a few different limits to be aware of, including object limits on the Free plan, automation limits, and more. Limits tend to vary depending on what pricing plan you’re subscribed to. Learn all about the various doc limits here.