A cross-sheet reference within the same file is giving me difficulties.
There are merged cells at D5:G5 on the second tab, "Disclosures & Identification," that include text.
There is a reference to that cell on the first tab. "="Disclosures & Identification" is the formula in use. D5. The formula just shows up in the cell rather than transferring the content from the field on the second tab.
I have tried using the entire set of combined cells in the reference (d5:g5), renaming the tab (in case the & was the issue), saving the file under a new name and updating to Office 2007 format (old version was 2003, but that should have worked anyway), and doing what I believe to be an appropriate amount of searching for the solution (with no luck). Any suggestions as to why this could not be working are welcome.