Cell Linking - Updating Source Sheet

kdashnaw

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.

Thanks!

Kelsey

Andrée Starå

Hi @kdashnaw

I hope you're well and safe!

Strange! It almost sounds like it's set up the other way, so the source is the destination.

Have you double-checked?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

kdashnaw

Hi there,

Not sure, but I can check on which way we are linking. I also want to note that the schedule sheet we are trying to link from also has formulas in every cell. Not sure if this makes a difference or not?

Thanks,

Kelsey

Andrée Starå

@kdashnaw

Happy to help!

Yes, double-check and let me know.

Formulas shouldn't make a difference.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!