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 |
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) |