About 10 days ago via this medium I was shown how to count the # of
worksheets using "INDIRECT".
Since Monday I have been struggling with a workbook that seems
self-corrupting.
My workbook has about 100 worksheets; each worksheet contains an
amortization schedule for the debt on a vehicle.
All amortization schedules have an identical structure.
Size of workbook is just under 30MB.
Problem is the workbook will not open properly. Error messages include
"cannot read file" and "damage to the file was so extensive that repairs were
not possible".
In my development of this workbook I progressively saved under different
version names and have been able to surmise that my problem began when I made
a modification to the amortization table while grouping all the worksheets
together (at that point probably <50 worksheets). Normally this should not
have been a problem. My question is, does EXCEL not "work" properly when I
have a combination of very large workbook and INDIRECT? My plan is to start
over limiting workbooks to 10 worksheets only and linking workbooks to
combine results. Any suggestions/wisdom for avoiding this mess in future
would be appreciated.
Many thanks,
Stephen Powell