Numbered Lists

[geoff_durham]

I have created a spreadsheet that formulates Numbered Lists as a Row
Identifier based on the location of the data within subsequent columns.
This works well, expect for two things:

1. Makes the Document too big. The complete spreadsheet is 16
Worksheets big and has increased in size to 23MB.

2. Too slow. Whenever a component is changed, the calculation time
slows down the process to a crawl.

To see one of the Worksheets see
http://users.cyberone.com.au/gdurham/NumberedLists.xls.

To see the formulae - Unhide Columns A through to R.

Can anyone offer any alternatives or nicer ways to do this.

Thanks,

Geoff.

 

[Otto Moehrbach]

As a first guess, I would say that your file is that big because Excel
thinks the file is bigger than it actually is. Do this for each sheet in
the file.
Find the last occupied cell in the sheet. Do this manually by scrolling to
that last cell.
Note that cell address.
Now do Ctrl-End. That takes you to the cell that Excel thinks is the last
cell of your data. Note that cell address.
If those 2 cells are widely apart, that could explain why your file is so
large.
Post back for some remedies if that is the case. HTH Otto

 

[geoff_durham]

Thanks Otto, but the end of the document as perceived by Excel is only
a few lines below the text. I think the problem more relates to the
fact that because the formula for each line is dependant on the line
above it, if you change a line all calculations in the lines below are
recalculated. I was hoping that someone has done something similar or
a formula guru could have a look at my logic.

Regards,

Geoff.