I’m asking this question as a precaution due to Murphy’s law. So I set up this huge production report for our manufacturing plant last year. The folders/files are set up as follows

2010 production report (folder)
Unit 1 (sub-folder)
Unit 1 File 1 (feeds file 2&3)
Unit 1 File 2 (feeds file 3)
Unit 1 File 3
Unit 2 (sub-folder)
Unit 2 File 1 (feeds file 2&3)
Unit 2 File 2 (feeds file 3)
Unit 2 File 3

There is more to them but this is the basic format. I realized now I should have named the main folder production report and then have sub folders for the years. If I change the main folders name will all the formulas within the files in the subfolders automatically change the mapping to the new name? I’m running Excel 2007, I did a test run with some dummy folders and files and it worked but I just want to confirm that they will remap to the new name? Thanks