If it worked once, it should work twice.... unless....
Your workbook may have gotten set to Manual calculation mode. This can
happen if you open a workbook set that way and later open other workbooks
during the same session.
You mentioned refreshing the naming of the list. I have seen Excel lose
track of named ranges in the past (older versions of Excel as 97, but not
lately). It may have done that. Try changing the formula to use the actual
addresses of the upper left/lower right cells of the table instead of the
name you gave the range and see if that helps. Also, you can use Insert |
Names to find the name of the table and see if it still points to the proper
range.
