Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Wierd Execl "Memory" problem
This started happenning this morning and seems like a bug. I am pulling data
from dde. The formula looks like this: ='@recombiner!TA_SRV'|LIVEQUOTE!'LIVEQUOTE;1022;10 03={''+CTXKK''}' I need to copy and paste this formula when I add a new symbol, ie CTXKJ. So I copy the formula, paste it into a new cell and then change the symbol. however, I accidently type in the symbol with a lower case final character, CTXKj. The dde server is case sensitive, so I get a #N/A. Now this is the wierd part - when I change the last character to an uppercase J, hit enter and still get the #N/A. I look back into that cell and the j is back in small caps and no matter where in the workbook that I try to change this symbol it automatically reverts back to small caps. What the $#$%@? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Wierd Execl "Memory" problem
Check your autocorrect options.
-- David Biddulph "pat" wrote in message ... This started happenning this morning and seems like a bug. I am pulling data from dde. The formula looks like this: ='@recombiner!TA_SRV'|LIVEQUOTE!'LIVEQUOTE;1022;10 03={''+CTXKK''}' I need to copy and paste this formula when I add a new symbol, ie CTXKJ. So I copy the formula, paste it into a new cell and then change the symbol. however, I accidently type in the symbol with a lower case final character, CTXKj. The dde server is case sensitive, so I get a #N/A. Now this is the wierd part - when I change the last character to an uppercase J, hit enter and still get the #N/A. I look back into that cell and the j is back in small caps and no matter where in the workbook that I try to change this symbol it automatically reverts back to small caps. What the $#$%@? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Wierd Execl "Memory" problem
All autocorrect options are disabled
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Wierd Execl "Memory" problem
"pat" wrote: All autocorrect options are disabled This happens for all text that I am entering into a cell. Whatever the cases of each character that I enter the first time, Excel will not let me change it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing from Excel Sheet Problem | Excel Discussion (Misc queries) | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |