Hi All, I created 2 MS Excel worksheets with VLookup formulas which worked fine. When the worksheets were opened on another computer the formulas added the formulas added the file locations to the formulas. i.e.. Instead of =VLOOKUP(A2,'[... it has =VLOOKUP(A2,'C:\Documents and Settings etc... Can anyone tell me why the C:\Documents and settings was added? Thank You in advance, Al

Because at the time, you had multiple workbooks open on your computer. There is a possibility you accidentally made an external link to another workbook. This can result in the behavior you're seeing.

Does your workbook as if you want to update external data when you open it? That's a sure sign.

Thanks for responding JBeaucaire,

The formulas revised themselves to include the file locations but they did not function as designed. I decided to consolidate everything into a single wookbook to keep all references self contained. Thanks again and enjoy your weekend, Al