Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On my file server, some Excel files lost their path.

For example:

=if(A2='\\172.168.1.1\SHARING\LANAIM\Gest_Qual\05__REG\04__Gest\[file1.xlsx]data'!$A2;2;False)

What they turned into was:

=if(A2='\\172.168.1.1\04__Gest\[file1.xlsx]data'!$A2;2;False)

How can I solve this problem?

share|improve this question
    
the formula has changed? Have you tried looking at the Links in the workbook and change the source of the file there? Or define a name in the workbook and use that for your path, and thus have a definite path defined where you control it. – datatoo Jun 14 '12 at 14:43
    
Not the formula, only the path. the name does not changed, nor the path. Only the path loses information of destiny. – Góis Jun 15 '12 at 9:29
up vote 0 down vote accepted

Use the Edit > Links command to change all links to external workbooks at once.

share|improve this answer
    
i'm use this to see existe error. but not ressolve my problem. the path lose informacion alone. ty for help – Góis Jun 15 '12 at 9:31

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .