Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Clear formula memory?
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Clear formula memory?
Autocorrect may be kicking in and correcting when first 2 characters are
entered in uppercase. Uncheck that option in the Autocorrect options. Gord Dibben MS Excel MVP On Tue, 02 Jun 2009 11:45:30 -0400, Matt Williamson wrote: 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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Clear formula memory?
Gord Dibben wrote:
Autocorrect may be kicking in and correcting when first 2 characters are entered in uppercase. Uncheck that option in the Autocorrect options. Gord Dibben MS Excel MVP On Tue, 02 Jun 2009 11:45:30 -0400, Matt Williamson wrote: 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 I turned off every autocorrect option. It still happens. The only way I've found to stop it is to delete EVERY instance of that formula in the spreadsheet, save/close and re-open then type it fresh in uppercase. Not fun with about 600 formulas across multiple sheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
How to minimize the formula cell memory? | Excel Worksheet Functions | |||
How to measure how much cell formula memory to be used? | Excel Discussion (Misc queries) | |||
How to save the cell formula memory on worksheet? | Excel Discussion (Misc queries) | |||
Any different between Excel 2007 and 2003 on formula memory? | Excel Discussion (Misc queries) |