view exact range in cross sheet reference

Melinda Tempfli

Hi All,

How can I see in a formula created by someone else what are the exact cells included in the range in cross sheet reference? I managed so far to identify the reference sheet, however in the edit reference range window it does not show what is the range used as of now.

Thanks!

Andrée Starå

Hi @Melinda Tempfli

I hope you're well and safe!

Try accessing it again because sometimes it doesn't show the first time.

Did that work/help?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Melinda Tempfli

Hello @Andrée Starå !

Thank for the reply. I have tried by now several times, and it doesn`t look to be working. Maybe I don`t know what to exactly look at, I am not sure... Could you share, by any chance, a print screen which works for you? Maybe this could help me...

Thanks!

Dale Murphy

@Melinda Tempfli Do you have full access to the referenced sheet? Have you scrolled completely side to side to look for the column? That should reveal the selected range.

dm