I just made an accounting spreadsheet using Excel 2003 with one worksheet each for 50accounts. Every cell in the summary worksheet sums the corresponding values from every account. I was recently asked to add 30 extra accounts in to prepare for future changes in accounting. After adding the 40 worksheets, I went into the summary worksheet and pasted the new formula (written seperately) into the cells. I have tested this several times, and the formula is always summing from the new worksheets. However, I recently discovered the following:
- In these cells, the formula is cut off, sometimes in the middle of a worksheet's name.
- If I add anything to the formula, Excel notifies me that the formula is too long.
- Despite this fact, the formula is still working properly, and summing from all 90 worksheets.
I am thankful that the formula is working, but I am worried that they may be fragile, and someday unexpectedly stop working. Is this something I should worry about?
Bookmarks