Forum Discussion
Link Cell from different workbook in same folder
Hi, I am looking a way to link a cell in another workbook that will move as I copy the whole folder. For example, I have folder #1 with Subfolders. I linked a cell in Folder1\subfolder1\excela to...
Hi Kayenee
Within a workbook, Excel is very clever and if you change something, move something, delete something, Excel adjusts all the cell references because it is holding everything to do with the active workbook in memory.
But Excel is not able to adjust external file references when you move linked files around on your computer.