Cell Linking - Updating Source Sheet
Not sure if this has been answered before and if so, apologies, I could not find anything relevant.
My team has been trying to link from a 'schedule' sheet out to smaller sheets so that we no longer have to manually update the smaller sheets. Unfortunately, we have found that whenever we need to update the linked cells in the source sheet (schedule), we have to break the link in order to update that cell.
Are we doing something incorrectly here? Manually updating these smaller sheets is wearing on my team.
Help Article Resources
Check out the Formula Handbook template!