I created a workbook, called Flow Charts, that I use to track the
statistics of the sales agents on my team. The flowcharts track the
following statistics: Retention, Adherence, Quality Scores, Handle
Time, and Cross-sells. I created the master sheet and tested it.
Worked like a charm. The problem is when I copied the master sheet so
that everyone on my team had his or her own sheet, the data did not
populate properly. Here is a sample equation pulled from one of my
cells:

=IF(ISERROR(VLOOKUP($B$1,'C:\Documents and Settings\aksaunders\My
Documents\Team Daily Stats\Month 3\[Daily Stats March wk
1.xls]Retention'!$B$1:$AS$40,43,FALSE)),"",VLOOKUP($B$1, 'C:\Documents
and Settings\aksaunders\My Documents\Team Daily Stats\Month 3\[Daily
Stats March wk 1.xls]Retention'!$B$1:$AS$40,43,FALSE))

In this equation, the information contained in B1 is the first name of
my sales agent. The cell containing this formula should return the
value in the cell that is in column 43 and in the same row as my sales
agent's first name. On the copied sheet, it doesn't work!The data is
pulled from several different sources and I have verified the paths in
every cell. Does anyone know why this might happen?