is there a way around this? I have some formulas, all sumif's, that work fine,, but only when all the workbooks in the formula are open. When I open just the workbook w/ the formulas in it, regardless if I choose to update external links or not, I get a #VALUE! error. As soon as I open them, the correct values appear.
The book w/ the formulas in it will be given to other users as read-only and they don't have access to open the other workbooks... How do I get around this? I also want the formulas to stay because every so often I will have to change the values. Thanks!
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!