I have a work book containing a summary page that lists the contents of multiple like forms in the same workbook at one line per form. Basically, the summary page shows names and address of people who have registered for an event.
One cell in the summary page is displaying the formula, not the data from the form it's pointing to. I've pasted the format from other cells to this one cell to try and turn off the audit formula mode. If I change the cell pointer to another cell in the form, the data appears but when I change the cell pointer back, I get the formula again. It seems to be one specific cell ='Attendee 2'!$C$6
This formula is in cell C3 of my summary page. It's pointing to a tab called Attendee 2, cell C6. No matter where I put this formula, I get the formula audit mode. If I change the pointer to ='Attendee 2'!$c$5, I get data. As soon as I change it back to c6, I get the formula. If I turn formula audit mode on for the sheet, all formulas appear, but, when I turn off the formula audit mode, everything goes back to showing data except this one cell. This is really hard to describe but does anyone have a clue as to what's going on?
Bookmarks