View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich F Rich F is offline
external usenet poster
 
Posts: 10
Default Formula Result Change when Workbook Sent by E-mail

I've got a workbook with a couple of VLOOKUPs pointed to within the same
workbook. When I send the workbook via e-mail, the recipient gets
different/incorrect values where ever the Vlookup formulas are when they open
the file (punching F9 or any variation does nothing). When they send the
workbook back to me and I open it, the VLOOKUP values are incorrect also and
using any variation of F9 is fruitless, but if I go to the Raw Data page
(where the VLOOKUPs are pointed to) and filter on it, suddenly the VLOOKUPs
reflect the proper data--however, if the original recipient tries to do the
same thing, the VLOOKUPs still show incorrect info.

When I open the original workbook on my laptap, there are no issues--works
like it should.

I've sent hundreds of these kinds of the workbooks in the past and never had
this issue. This was a uniquely created workbook (meaning I didn't cut/copy
into an exisitng workbook).

Any ideas?
--
Rich F