Ask Experts Questions for FREE Help !
Ask
    johnal's Avatar
    johnal Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Dec 11, 2008, 09:26 AM
    Excel formula vs file location
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Dec 12, 2008, 01:44 AM

    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.
    johnal's Avatar
    johnal Posts: 2, Reputation: 1
    New Member
    		  
    #3

    Dec 12, 2008, 02:03 AM
    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
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Display formula in Excel [ 4 Answers ]

Hi, Can you please show me how to display all formulas in a spreadsheet? I already calculated the data using formulas in a spreadsheet, now I just want display the formulas. Are there any keyword shortcuts. Many thanks.

Excel formula [ 1 Answers ]

I have more questions about excel formula. In one column I have data appearing, as either a 1 or 2, at random as I input it. Each column has around 120 rows. In the row at the bottom I created a formula to calculate how often, on average, the data appears in that column. 1st how do I get each row...

Excel formula [ 3 Answers ]

I am using Excel 2007. I have 2 Sheets. In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one contains the department he works in. In the second sheet I have drop down list of the names of employes and the...

Excel Formula [ 1 Answers ]

Hi I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work. Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00 But...

View more questions Search