bad links

O

Ovidiu

I did some formulas with figuers from other files. the problem is tha
when i open the sheet the links to the other documents don't wor
anymore. i have to open the source sheets so that the figuers appear
how can i make the links work even if the source sheets are no
opend??? Thx, Ovidi
 
S

swatsp0p

do your links have the path to the file, the file name and the shee
name? e.g.:

=IF('C:\Documents and Settings\defaultuser\My Documents\M
eBooks\[Book4.xls]Sheet1'!$C39<>"",'C:\Documents an
Settings\defaultuser\My Documents\My eBooks\[Book4.xls]Sheet1'!$C39,""
 
O

Ovidiu

the formula looks something like that:
=SUMME('c:\Vertrieb Sales\500-600 \580 Planung und
Berichtswesen\Umsatz-_ BE-_Anzahlungsplanung\per.
Kostenplanung\GJ0405\082005\[per. kostenplanung.xls]#Rechnungen PjM
u.a.'!$H$5:'c:\Vertrieb Sales\500-600 \580 Planung und
Berichtswesen\Umsatz-_ BE-_Anzahlungsplanung\per.
Kostenplanung\GJ0405\082005\[per. kostenplanung.xls]#Rechnungen PjM
u.a.'!J5)
 
Top