Each year he creates a standard accounts receivable spreadsheet which starts off with the previous year's balances. So, in the 2007 A/R sheet, the first column has values for projects at the end of December 2006. Instead of copying the values of the December 2006 cells over to the 2007 A/R sheet, he links the 2007 cell to the appropriate 2006 cell.
So far, so good.
What's weird is when you look at the file path for the linked 2007 cell. It should read something like "His Name.server/My Documents/2006 Financial Records/2006 Accounts Receivable.xls[SHEET AND CELL]." Instead, the file path reads "His Name.server/My Documents/2006 Financial Records/2007 Financial Records/2006 Accounts Receivable.xls[SHEET AND CELL]." It's saying there's a file folder in the 2006 Financial Records folder that is named 2007 Financial Records.
And what's weirder still is that the linked 2007 cell displays the correct value from the 2006 cell. This is a seemingly harmless quirk of Excel, but I wondered if anyone had any insight into this and whether or not there's something more seriously wrong with the file system.
Thank you so much for your help!
-- Kevin Pat
Edited by Kevin Pat, 24 December 2008 - 12:04 PM.