Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a formula to change data result weekly. | Excel Worksheet Functions | |||
Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
Protect the formula but change result. | Excel Worksheet Functions | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) |