J
JL
Hi,
I think this should be a easy one.
Well, this is the problem. I am buiding a template of
formula on one Excel sheet and copy them into a newly
created sheet. Two problem show up. I think I have
resolve the first one.
1) When I used paste special just paste "value" without
the ignore blank clicked. It will insert a blank space at
the before the first character (in this case "=") and the
last character (in this case ")").
For example:
Formula,
"=SUMIF(F5:AN5,"<>#REF!")"
It will actually looks like this,
" =SUMIF(F5:AN5,"<>#REF!") "
After the ignore blank click, it looks fine.
2) Why do I have to actually go into the cell to make the
formula work. I try the "Tool", "Calculate", "Calc
Sheet"/"Calc Now". None of them works. This caused a
huge problem. I do not want to go to every cells in the
sheet to make the formula activate.
Thank you for your help.
I think this should be a easy one.
Well, this is the problem. I am buiding a template of
formula on one Excel sheet and copy them into a newly
created sheet. Two problem show up. I think I have
resolve the first one.
1) When I used paste special just paste "value" without
the ignore blank clicked. It will insert a blank space at
the before the first character (in this case "=") and the
last character (in this case ")").
For example:
Formula,
"=SUMIF(F5:AN5,"<>#REF!")"
It will actually looks like this,
" =SUMIF(F5:AN5,"<>#REF!") "
After the ignore blank click, it looks fine.
2) Why do I have to actually go into the cell to make the
formula work. I try the "Tool", "Calculate", "Calc
Sheet"/"Calc Now". None of them works. This caused a
huge problem. I do not want to go to every cells in the
sheet to make the formula activate.
Thank you for your help.