Eric0568
12-16-2007, 10:12 AM
I have a named range named "Matrix" on a sheet called "Matrix" that I look up values from with a VLOOKUP in another sheet.
The command works perfectly on the sheet that I originally programmed.
When I make a COPY of that sheet, however, there is a problem.
If I go make a change in the Matrix, and view the results on the original sheet, it is updated correctly. If I view the results on the COPIED sheet, it does not update until I do one of two things:
1. Save, close, and reopen the file (no, saving alone does not do it).
2. Cursor in the formula bar and hit enter, forcing an update of that cell (and that cell alone).
I know that Excel does not recalculate cells unless something has changed about the cells that the cell in question references, but I have changed the information that the VLOOKUP cell references, so it should re-calc.
The weird thing is that it DOES on the original sheet, but not the copied sheet.
Neither the cell that contains the VLOOKUP, nor the cell that it references contains any VBA routines, so that is not it either.
And my calculation is set to auto.
Much thanks in advance.
:help
</IMG>
The command works perfectly on the sheet that I originally programmed.
When I make a COPY of that sheet, however, there is a problem.
If I go make a change in the Matrix, and view the results on the original sheet, it is updated correctly. If I view the results on the COPIED sheet, it does not update until I do one of two things:
1. Save, close, and reopen the file (no, saving alone does not do it).
2. Cursor in the formula bar and hit enter, forcing an update of that cell (and that cell alone).
I know that Excel does not recalculate cells unless something has changed about the cells that the cell in question references, but I have changed the information that the VLOOKUP cell references, so it should re-calc.
The weird thing is that it DOES on the original sheet, but not the copied sheet.
Neither the cell that contains the VLOOKUP, nor the cell that it references contains any VBA routines, so that is not it either.
And my calculation is set to auto.
Much thanks in advance.
:help
</IMG>