dan_l
Active Member
So here's one:
I've got a noisy workbook I'm trying to decode. There seems like there's a few moving parts here.
It's a calculator. The part number (input) has several components. Based on these components, the calculator determines price.
1. The input worksheet has a couple of columns. Almost all have only #value or #n/a until one of the cells is populated with a part number.
2. Once I input a part number, the workbook goes into about a 3 minute calculation cycle. Annoying.
3. Once the part number is inputted, a few of the cells populate. Those cells are filled with the array formula: {=TABLE(,I3)}
4. I is column where you input the part number. I3 filled with a valid part number.
5. There is no named range called Table. There is no vba module associated with this workbook.
6. Interestingly, I3 is references elsewhere in an area called "database manipulation". It evaluates only that part to establish price with a bunch of lookups.
7. I can't edit the structure of the input worksheet. Excel returns that it can't change part of a data table.
8. PUP identifies this workbook as Excel 8.
Anybody have any guesses as to what I may be looking at?
I've got a noisy workbook I'm trying to decode. There seems like there's a few moving parts here.
It's a calculator. The part number (input) has several components. Based on these components, the calculator determines price.
1. The input worksheet has a couple of columns. Almost all have only #value or #n/a until one of the cells is populated with a part number.
2. Once I input a part number, the workbook goes into about a 3 minute calculation cycle. Annoying.
3. Once the part number is inputted, a few of the cells populate. Those cells are filled with the array formula: {=TABLE(,I3)}
4. I is column where you input the part number. I3 filled with a valid part number.
5. There is no named range called Table. There is no vba module associated with this workbook.
6. Interestingly, I3 is references elsewhere in an area called "database manipulation". It evaluates only that part to establish price with a bunch of lookups.
7. I can't edit the structure of the input worksheet. Excel returns that it can't change part of a data table.
8. PUP identifies this workbook as Excel 8.
Anybody have any guesses as to what I may be looking at?