> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nextedy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Large Sheets

> How large a sheet Nextedy RISKSHEET supports, how long loading and exporting take, and how to configure a sheet with thousands of risk items and tens of thousands of rows.

A risk sheet grows faster than the analysis behind it. Every risk item takes one row per task linked to it, and a task — a risk control or mitigation — that serves many risk items appears in a row under each of them. A few thousand risk items with around ten shared controls each make tens of thousands of rows. Since 26.11.0, Risksheet opens and exports sheets of that size.

## Supported Size

* **Tested size:** one sheet with about 8,000 risk items and 86,000 rows.
* **No fixed row limit.** Risksheet itself does not cap the number of rows. The practical limit is the browser's memory: the loaded rows stay in the browser tab, and Chrome lets a tab use about 4 GB.
* **Timeouts:** a load has to finish within the request timeouts of Polarion and of any proxy in front of it. Configure the sheet as described below so that it stays well within them.
* **Document tree:** a `$tree` tree can hold up to 500,000 rows; administrators can raise the limit. See [Size Limit](https://learn.nextedy.com/risksheet/reference/api/document-tree-and-link-renderer.md#size-limit).

## Load and Export Times

Measured on a test server (Polarion 2606) in Chrome, with the server already warm. "Before 26.11" is Risksheet 26.10.1 on the same sheets.

| Sheet | Load before 26.11 | Load in 26.11, original column scripts | Load in 26.11, configured for a large sheet |
| - | - | - | - |
| about 2,000 risk items, 20,000 rows | 35–50 s | about 28 s | about 6 s |
| about 8,000 risk items, 86,000 rows | does not open | about 35 s | about 17 s |

| Sheet | PDF export before 26.11 | PDF export in 26.11 | Excel export before 26.11 | Excel export in 26.11 |
| - | - | - | - | - |
| about 2,000 risk items, 20,000 rows | about 3 min | about 13 s (about 3,000 pages) | about 2 min | about 16–20 s |
| about 8,000 risk items, 86,000 rows | runs out of browser memory | about 45–55 s (about 13,000 pages) | not measured | about 47 s |

Both sheets are risk analyses whose risk controls are shared by many risk items, with four `serverRender` columns that list linked work items: the controls' implementations, their evidence, the related functions and further risk items. "Original column scripts" means those columns as first written, following links from `$item`. "Configured for a large sheet" means the same four columns rewritten with `$tree` and `$render`, as described in [Speed Up Server-Render Columns with the Document Tree](https://learn.nextedy.com/risksheet/guides/advanced/speed-up-server-render-columns-with-the-document-tree.md), and `global.simpleLinks` turned on; the columns show the same content.

Your times depend on the server, the network and above all the configuration — mostly the columns that show linked work items. The first load after a Polarion restart takes about twice as long. A document opened in a revision or a baseline takes longer than its current version.

## While a Sheet Loads

While the rows arrive, the footer shows **Loading…** and a progress bar in place of the row count. The bar fills as the risk items come in; hovering over it shows how far the load has come — **The server is preparing the rows** before the first rows arrive, then for example **618 of 1,500 risk items received, 2,471 rows so far**. Until the number of risk items is known, a short segment moves back and forth along the bar. When the load finishes, the footer shows the row count again.

![A Risksheet grid while it reloads, with the footer showing Loading and a progress bar about 40 percent full](https://mintcdn.com/none-17b4493f/7K9VJz-M40Ht1WZc/risksheet/images/large-sheets/sheet-loading-progress.png?fit=max\&auto=format\&n=7K9VJz-M40Ht1WZc\&q=85\&s=40ab970e6dfa8ba6df2bcc0b58581442)

Reloading a 6,000-row sheet: the toolbar's reload icon spins, and the footer shows the load part-way through.

If the load stops with **The server response ended early, the sheet was not loaded completely.**, see [When a Load Ends Early](https://learn.nextedy.com/risksheet/troubleshooting/performance-slow-loading.md#when-a-load-ends-early).

## Configure a Large Sheet

A large sheet needs no special setting to load. How long it takes depends mostly on the columns that show linked work items. In order of effect:

* **Use simple link cells.** Set `global.simpleLinks: true`. Item-link, multi-item-link and task-link cells then show the type icon, ID and title and open in a new browser tab, without Polarion's hover card and revision icon. See [Global Settings](https://learn.nextedy.com/risksheet/reference/configuration/properties-index.md#global-settings-global).
* **Read linked items through the document tree.** A `serverRender` column that follows links from `$item` — from a risk item to its controls, from a control to its evidence — is usually the slowest part of a large sheet. Rewrite it with `$tree` and `$render`, as described in [Speed Up Server-Render Columns with the Document Tree](https://learn.nextedy.com/risksheet/guides/advanced/speed-up-server-render-columns-with-the-document-tree.md).
* **Keep task columns independent of the risk item.** A `serverRender` column of the task that reads `$masterObject`, or hands its work to a macro it does not define itself, `#parse`, `#include` or `#evaluate`, makes the whole sheet load slower.
* **Define tasks by one link role.** A sheet whose task definition names a single link role loads faster than one that uses a query or several link roles.
* **Turn off the reload after save.** With `global.refreshOnSave: false`, saving does not reload the whole sheet. If the sheet has multi-item link columns, use Risksheet 26.11.2 or later: in earlier versions their cells can show empty after a save until the sheet is reloaded. See [Slow Page Loading](https://learn.nextedy.com/risksheet/troubleshooting/performance-slow-loading.md#disable-refresh-on-save).

Save the sheet configuration and reload the sheet for a change to take effect.

## Exporting a Large Sheet

PDF and Excel exports keep the page responsive. A progress notification names the step the export is in and how far it has come, and changes to **Done** when the file has been downloaded. During a PDF export the sheet is read-only until the export ends; during an Excel export you can keep editing. Exporting from Flat table view is faster than from a hierarchical view. See [Export to PDF](https://learn.nextedy.com/risksheet/guides/export/pdf-export.md), [Export to Excel](https://learn.nextedy.com/risksheet/guides/export/excel-export.md) and [Export Performance Issues](https://learn.nextedy.com/risksheet/troubleshooting/export-performance.md).

## See Also

* [Speed Up Server-Render Columns with the Document Tree](https://learn.nextedy.com/risksheet/guides/advanced/speed-up-server-render-columns-with-the-document-tree.md) — rewrite columns that follow links
* [Document Tree and Link Renderer](https://learn.nextedy.com/risksheet/reference/api/document-tree-and-link-renderer.md) — reference for `$tree` and `$render`
* [Slow Page Loading](https://learn.nextedy.com/risksheet/troubleshooting/performance-slow-loading.md) — diagnose a slow sheet step by step
* [Export Performance Issues](https://learn.nextedy.com/risksheet/troubleshooting/export-performance.md) — slow PDF and Excel exports


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.