delete "unable open http"

**triaji** · 10-16-2011, 08:26 AM

Everytime i open this workbook, excel always say "Unable open http://ididjktapp11/.....xls. cannot locate the internet server or proxy server."

anyone know how to delete/fix it?

Thanks in advance

**TMShucks** · 10-16-2011, 08:47 AM

I'm guessing you have links to other workbooks. It's possible the linked files no longer exist or have been moved to another location.

You need to edit the links and either break them or change the source location.

Regards

**triaji** · 10-16-2011, 09:56 AM

[QUOTE=TMShucks;2620668]I'm guessing you have links to other workbooks. It's possible the linked files no longer exist or have been moved to another location.

You need to edit the links and either break them or change the source location.

Thanks TMShucks,

But how i find that links? i cannot find it.

Many thanks

**TMShucks** · 10-16-2011, 12:37 PM

Look on the Data Ribbon, Edit Links ... it will tell you the name of the sheet and where it expects to find it.

Also, Column M on Accrued-AGT has:

=IF(ISERROR(VLOOKUP($D6,'Y:\ACC-Private\3. MONTHLY REPORT\2. EXTRACOM\Extra Comm 2011\[08-WP Extracomm Agt 11.xls]Grouping BSPL'!$A$2:$C$556,3,0)),"-",VLOOKUP($D6,'Y:\ACC-Private\3. MONTHLY REPORT\2. EXTRACOM\Extra Comm 2011\[08-WP Extracomm Agt 11.xls]Grouping BSPL'!$A$2:$C$556,3,0))

... copied down.

Regards