Relative formula not updating when copying
You can copy a formula from one worksheet to another using the same process.
After you copy the formula, choose the destination worksheet, select the destination cells and paste the formula.
This issue is really frustrating me, and I'm not sure if I'm just googling with the wrong keywords or what.
I've discovered that when you link to another workbook in Excel, if you close the file and then attempt to move or copy it, the moved/copied workbook will have all of its links broken. However, if I copy Workbook1 and paste it directly onto the desktop and open it, Excel informs me that my link is broken.
It's a good thing that Excel doesn't facilitate the abhorrent practice of absolute paths.