Forum Discussion
Excel #REF! error with connected sheets
I have an issue with my excel sheets.
I habe three sheets that are connected to each other. Lets call them A, B and C.
B and C are input sheets where I can put in my data. A is a sheet where everything should be pulled together.
Now I have the issue that when I open A befor B or C (it always has to be activated for editing and the connections have to be uptdated.) that I get #REF! errors in A. I have to open B and C first to not have that error in A.
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?
4 Replies
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?
