Reference a cell in another numbers file.

I'll take the other side of the issue. Numbers (unlike Excel) allows you to easily have multiple tables on one sheet. So there is plenty of room to organize work within one document.

Having one self-contained document has lots of advantages. The main one is that your links won't break when you happen to move one document within the file system. Another one is that it works cross-platform.

So I'd recommend thinking about restructuring your document to take advantage of the Numbers design and its powerful built-in features.

For a checking account, for example, consider keeping all its data in one table rather than splitting it out by year. You can easily use filters, Pivot Tables, Categories or SUMIFS to display and extract yearly information. That is easier (and less error-prone) than carrying EOY balance over as a BOY balance in another table via breakable links.

SG

Please send this as a request to Apple

Product Feedback - Apple

I fully agree with you, it would be helpful if we would get this option.

Ralf

Modern Macs running recent versions of Numbers should be able to handle your financial data in one document with aplomb, unless you're using hundreds of "volatile" functions that need to recalculate every time you make a change.

You might consider whether you need a separate sheet for each account. You can easily organize each account in its own table and also easily have more than one table on each sheet.

You are probably aware that sheets are easily duplicated. (Go to the tab name at the top and choose Duplicate. You can also Copy Sheet, go to a separate document, then Paste Sheet. That can be particularly handy when starting a new period, etc. if you absolutely must keep each time period separate.)

I find searching for historical transactions is MUCH easier if like data is kept together rather than being scattered around in different tables on different sheets. And to view just a specific year it's just a matter of a second or so to apply a filter, probably even quicker than navigating to some other table on a separate sheet perhaps in a separate document).

Anyway, food for thought. I think you may find you can save a lot of time and trouble by restructuring your documents to take better advantage of powerful features in Numbers and avoid reliance on breakable links.

SG