Forum Discussion
Excel #REF! error with connected sheets
I guess it has something to do with the way Excel is calculating references in my file.
Is there a way where I do not have to open B and C before beeing able to edit A without issues?
Your guess is pretty certainly the issue--A is calling on B and C to be complete. So, yes, they need to be available.
I have a workbook setup that is much the same. I wouldn't want to be able to edit A without reference to B and C, because I'd not be doing those edits/corrections/revisions/modifications in such a way that I could know it was going to work when B and C were open. Said another way, I think you'd be potentially exposing yourself to erroneous edits; not necessarily doing so, but potentially. Whereas if they're open, you know you're doing edits that work with the full array of data.
Thank you for responding so quickly!
I know it sounds like it would not make sense to eddit A without edditing B and C, but I'm not the only person using it.
A is a invoice sheet for a working group, which is connected to 16 individual worker sheets (B) and 10 kid sheets (C). All the workers put in their expenses throughout the month an then one person responsable for the invoce sheet has to check and print out the sheet every month. So a lot of people edditing the sheets. On top of that comes that these people are not very tech savy so Im trying to have a product that is very easy and intuitive to use.
But I guess they will just have to open on of B and C before using A, right?
Thank you for helping me 😄
Do we speak about sheets in one workbook, not about different workbooks?
- Different workbooks
Each having sheets from January to December.
An AI told me to disable the "Protected View", I will try to do that tomorrow. Do you have other things I could try?
