simply clicks? or is it F2 then Enter

Check to make sure that calculation is turned set on Automatic
Tools, Calculation (tab), calculation: [x] Automatic

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RHubbard" wrote in message
...

One of the Excel users here at UM has encountered a bizarre problem.

He is generating a report from our accounting system which he pastes
into an excel spreadsheet. He is using VLOOKUP to get data from the
pasted report which is used to update MTD and YTD accounts.

In general, it works fine except for this oddity:

In account numbers that are structured as XXXXX-XX (where X is a
numeric digit), the VLOOKUP function works fine. In some situiations
where account numbers are structured without a suffix XXXXXX VLOOKUP
will not return information UNLESS the users goes to the target sheet
and simply clicks in the cell that should be updated. At that point,
the data comes across. Whats Gives?


Thanks for the help.



Rick


--
RHubbard
------------------------------------------------------------------------
RHubbard's Profile: http://www.excelforum.com/member.php...o&userid=27406
View this thread: http://www.excelforum.com/showthread...hreadid=469192