Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.