Forum Discussion
Excel #REF! error with connected sheets
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?