I'm having a very odd issue that I can't seem to figure out what is
going on. I have a spreadsheet that contains formulas that reference an
add-in that gets stock info. The add-in only recognizes tickers that are
in uppercase in the latest version. In earlier versions it didn't seem
to matter. I just recently upgraded to the latest version of this add-in
and none of the formulas where the tickers are in mixed case function
properly. The problem is, I can't change them to upper case. If I do, it
automatically reverts back to mixed case. I'm thinking there is some
sort of memory cache for formulas that it's reading from but I've turned
off every autocomplete feature that I can find. The odd thing is if I
close that workbook, open a new one and manually type the formula with
the ticker in upper case, then re-open the original workbook, every
instance where it was in mixed case changes to uppercase now. Is there
any way to control this "feature"? I've tried a Find/Replace but that
doesn't work. I'm pretty good with VBA if anyone can recommend a way to
fix it with code.

TIA

Matt