I have a workbook with a Summary sheet followed by x number of Status Report sheets. Status Report sheets are formatted identically. Due the nature of the data, I have merged cells (some are row-merged, others are column-merged) in both the Status sheets as well as my Summary sheet.
For Example:
On my Summary sheet I reference cell A15 on Sheet2 (one of many Status Report sheets). Formula in my Summary sheet reads =Sheet2!A15. The formula appears, rather than the data that is in Sheet 2, A15.
If I remove all Merges in both the Summary and Status sheets and redo the formulas, the information displays fine. As soon as I merge the cells, in some instances the data appears and in others it just displays the formula.
Any work around?
For Example:
On my Summary sheet I reference cell A15 on Sheet2 (one of many Status Report sheets). Formula in my Summary sheet reads =Sheet2!A15. The formula appears, rather than the data that is in Sheet 2, A15.
If I remove all Merges in both the Summary and Status sheets and redo the formulas, the information displays fine. As soon as I merge the cells, in some instances the data appears and in others it just displays the formula.
Any work around?