using someone else's spreadsheet

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

Hi

One of my work colleagues has created an Excel spreadsheet that pulls date
from another Excel file and use it in a chart. The files store production
deata for his shift

He keeps both files on his desktop

I asked him to email these files to me so that I can use them for my shift
too. He did this and I stored them on my desktop (which is on a separate
PC)

When I try to alter the cell references, it won't let me because it says the
path is incorrect

The 'old' cell reference is:

=SERIES('C:\Documents and Settings\daviesp\Desktop\[EFFICIENCY aug
2006.xls]SEPT'!$A$4,'C:\Documents and Settings\daviesp\Desktop\[EFFICIENCY
aug 2006.xls]SEPT'!$B$3:$P$3,'C:\Documents and
Settings\daviesp\Desktop\[EFFICIENCY aug 2006.xls]SEPT'!$B$4:$P$4,1)

The new reference is:

=SERIES('C:\Documents and Settings\williamsp\Desktop\[EFFICIENCY aug
2006.xls]SEPT'!$A$4,'C:\Documents and Settings\williamsp\Desktop\[EFFICIENCY
aug 2006.xls]SEPT'!$B$3:$P$3,'C:\Documents and
Settings\williamsp\Desktop\[EFFICIENCY aug 2006.xls]SEPT'!$B$4:$P$4,1)

All I've done is changed daviesp to williamsp to reflect the fact that our
names are different

The location C:\Documents and Settings\williamsp\Desktop\EFFICIENCY aug
2006.xls definitrly exists

What am I doing wrong?

Thanks

Pete
 
Hi Pete,
When I try to alter the cell references, it won't let me because it says the
path is incorrect
Click to expand...

The easiest way to correct this reference (Excel calls this a Link) is using
the Edit Links options from the menu. In this dialog, select the file that
holds the source data. Then click change link and point to the file that is on
your desktop. Then click Open (or OK) and you should be done.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Jan Karel Pieterse said:
Hi Pete,


The easiest way to correct this reference (Excel calls this a Link) is
using
the Edit Links options from the menu. In this dialog, select the file that
holds the source data. Then click change link and point to the file that
is on
your desktop. Then click Open (or OK) and you should be done.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
Click to expand...

Thanks very much Jan

That worked

Pete
 
Back
Top