Reference Error

Bryan Letourneau

Hello,

I'm attempting to create formula that references a specific month but for some reason its showing as January 2022 Range 1, when every other column is correctly showing as February 2022 and its providing inaccurate information. Has anyone run into this before and have a fix?

Thanks

Julia C Peterson

Sometimes if you edit reference names things get messed up I've found. I usually delete the reference and start again. You can right click any cell on the main sheet and click "Manage References" and then delete that reference causing issues and create it from scratch

Bryan Letourneau

Hmm, first time I've run into that. I decided to remake the source sheet giving me issues and that seemed to address it. I'll definitely keep your advice in mind the next time it occurs.

Thanks!

Dan W

If you are "editing" a Reference,

In your formula highlight the reference you want change and select "Reference another Sheet" NOT Edit reference. That should fix the name.

Bryan Letourneau

I've done that, it continues to show January for that column only.

Julia C Peterson

Sometimes if you edit reference names things get messed up I've found. I usually delete the reference and start again. You can right click any cell on the main sheet and click "Manage References" and then delete that reference causing issues and create it from scratch

Bryan Letourneau

Hmm, first time I've run into that. I decided to remake the source sheet giving me issues and that seemed to address it. I'll definitely keep your advice in mind the next time it occurs.

Thanks!