Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using someone else's files
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using someone else's files
Try opening your file, and then click EDIT on the menu and select LINKS.
There will be a list of linked file and you can change the location of each file by clicking on the filename in the file source panel and then the CHANGE SOURCE command button and locate the file manually. This will update all linked formulas as well. -- Kevin Backmann "Pete" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using someone else's files
Thanks Kevin
That worked Pete "Kevin B" wrote in message ... Try opening your file, and then click EDIT on the menu and select LINKS. There will be a list of linked file and you can change the location of each file by clicking on the filename in the file source panel and then the CHANGE SOURCE command button and locate the file manually. This will update all linked formulas as well. -- Kevin Backmann "Pete" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seemingly random .tmp files | New Users to Excel | |||
How to update destination file with source files closed? | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) |