Noticed no one had replied to this, so I thought I would offer a
longshot.

1) The most times I notice people getting a #REF is because they are
vlooking a item in a Pivottable in another spreadsheet (without that
sheet being open). There are workarounds, etc, for that, but you said
nothing has changed, so I don't know why that would be the problem. If
you are vlooking up in a Pivottable, email me privately and I'll give
you some tips.

2) Click tools-options-transition-Sheet options. Toggle these
settings. Sometimes I have seen sheets display certain errors when
these are enabled or disabled. Just a wild troubleshooting step;
probably won't help.

Sorry I couldn't offer any better advice, but I at least wanted to give
you one response :).


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=526883