Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbered Lists
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbered Lists
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 wrote in message oups.com... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbered Lists
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare lists | Excel Worksheet Functions | |||
Capitalize Text if 2 lists are equal | New Users to Excel | |||
Excel - need a function to compare lists | Excel Worksheet Functions | |||
Numbered Lists! | Excel Discussion (Misc queries) | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions |