Cross Sheet References Disappeared to original sheet

System

This discussion was created from comments split from: All cross sheet references randomly removed from sheet.

Ciro Moreno

Hello,
This just happened to me here in 2025, the sheet hasn't been use by anybody but me, as I'm still on the phase of making the calculation for a dashboard, until yesterday was working fine and today out of the sudden all cross sheet reference are gone, when I go to manage references they are not there.

The only thing I did differently was to reference the same columns from a new sheet, now when I go to the source sheet black arrow at the bottom it only shows me the reference to the new sheet.

Are we only allowed to reference one sheet at the time?

Michelle Choate 2

You can reference as many sheets as you want, but the name can only be used once. So for instance if you have "Start Date" from one sheet, and need to use start date from another, you cannot name it the same thing, otherwise it will all update to the new sheet.

I always recommend using "Sheet Name | Reference Name." Could that be what your issue is?

Genevieve P.

Hiya! Just jumping in here to send a tag notification.

@Ciro Moreno there's been a response to your question 🙂