Hi adn,

The second issue with the slowness of adding a row is probably due to running on a Windows NT or 2000 machine. This has been fixed, but we are still testing and have not released it yet. Because you are on a current Upgrades plan, you will get it automatically when it's ready.

The first issue might be because some formulas don't automatically update if a row is added. For example, =Sum(B5...B10) wouldn't update if you inserted a new row #7. Most formulas do update correctly, but for those that don't, you should check the formula syntax to make sure it's what it should be.

Regards,
Softrak Support

The formula you posted is a formula for the first period current year net change. It is looking at cell C8 to find the account and department to determine which amount will print. Do you have a valid account/department in cell C8? If so, what is the current year net change for that account? It may be possible that the amount in the data actually is zero.

If you insert a row immediately above this row, this formula does update correctly to $C9. If it doesn't for you, then likly the other issue with the slowness is also hindering the formula updating.

Regards,
Softrak Support

Hello Dan (?),

We are aware of the speed issue when adding rows into a financial statement. Also, adding a row may not correctly update all of the =SUM() formulas. Look for an improvement in these areas on the next release of Ledger.

In the interim, you will notice a significant speed improvement between running with your data on your local hard disk as opposed to over your network wire. Even if your network is running at 100 Mbits/sec, your local hard disk transfers data in much larger "hunks". Try copying your G/L data to a subdirectory on your hard disk and printing (and editing) your financial statements there). If you make changes to your Financial Statements, don't forget to copy them back to the network drive.

Regards

See what happens if you recalculate the spreadsheet before adding the row. To do this, simply press the F9 function key. If you see values change to zero before adding the row, then you know that it isn't the row addition causing the values to go to zero.

Please be aware that the financial report does not automatically refresh when you first open it. The values that appear in the cells are based on the last time this report was saved. If you have done a Year End since the last time this spreadsheet was used, all of the current year values will have been cleared to zero. This is what you should check:

- First open the spreadsheet. Are the values zero?
- Look in C8 (or C9) and note the GL account/dept
- If it's a valid account, go to your GL data and the account 'budget/history' screen. The top row to the left will contain the Net Changes for the first fiscal period. This is what the formula you posted here will read.
- In the financial report, click F9 to recalculate before attempting to change anything else.
- When the row is added, is the new cell reference in the formula (ie C9) pointing to a valid acct? Does C9 have a valid acct?

As posted earlier, we are aware of some issues with formulas not updating correctly when a row is added. However, the cell reference in the ADGET formula does update correctly, as you've seen. The issue likely isn't that adding a row is causing this, but something has changed in the data since the last time this report was saved. That could be simply that Year End was processed.

Regards,
Softrak Support