Administration › Time-Scaled Value Link Exports to Excel

Time-Scaled Value Link Exports to Excel

Excel has a 64-KB limit on the number of links that are exported to a worksheet. If you have configured links within your time-scaled value (TSV) cells, you can reach the limit. An Export to Excel operation does not complete successfully when the limit is reached.

A new option named Enable TSV links for Export to Excel provides a way to control how TSV links are exported. The option is selected by default so that all TSV links are exported.

If the option is not selected, TSV links are exported only up to the limit. When the limit is reached, the operation continues to export TSV values but without additional links.

Upgrade Action: (Optional) Clear the option to ensure the operation to export does not stop when the limit for links is reached.

Follow these steps:

1. Open Administration and from General Settings, click System Options.
2. In the Other section, clear the Enable TSV links for Export to Excel check box.
3. Save your changes.