I've run across a maddening issue with conditional text. Here's the scenario: I have a trifold piece with lots of price tables in it. These tables need to show different currencies and up until now, I've had no problem with them. In reworking some of the tables, I've had to add new prices (each in 5 different currencies). Ordinarily, I copy and paste from Excel, but now when I do that, apply the condition to the new price, and then move on to the next currency, the conditional text I just added is gone. Poof. Nothing. Just gone when I switch back to that currency. I suspect it has something to do with the new Mac version of Excel, but I have no proof of that and it's odd that the text pastes in just fine and I can apply a condition to it. If I type the text in by hand, it stays put and doesn't disappear. It's just copied and pasted text that vanishes. Something else I noticed when I took one of the tables apart and expanded the cells so I could see all of the conditional text at once is that there doesn't seem to be any consistency as to the order the different conditions appear: sometimes the newer text is in front and sometimes after what's already there. There's obviously a bug here somewhere, but I'm wondering whether anyone else has seen this phenomenon and if there's any way to work around it. With hundreds of cells to populate, typing thousands of prices by hand is going to take forever.
I'm running on a Mac Pro with 10.6.5, Office 2011, and nothing else out of the ordinary.
.
