Hello. My assistant and I are creating some financial documents in Excel 2010. We set up a DSUM formula that links to a trial balance Excel file in another worksheet. At times, when we open the file using the DSUM formula, if the trail balance is not open, all the DSUM formulas become VALUE errors until we open up the trial balance file.
Is there a way to make it so these VALUE errors will not show up without having to always open the trial balance file? We tried to use the edit links and update the links, but that didn't work. I was hoping there is a way around this problem. Thanks for anyone that can help us!
Dave
Bookmarks