software

All of a sudden some of my new formulas are appearing as the cell content
instead of the content being the value of the formula. Specifically, I have
several report sheets that show data from a database table range referenced
by cell named 'dedb' that look like:

=IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),quot;__________quot;)

I added a new column in my database range called tcontact and named to, but
when I copy the above formula to a cell to reference the new column, it does
not evaluate. It just shows:

=IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),quot;__________quot;)

What's going on here? I do have over 500 named ranges in my workbook, and
the workbook file is around 700KB, but I wouldn't think I was running out of
room or resources.

Appreciate your help.Hit Ctrl ` (the key to the left of quot;1quot;). You probably hit it by mistake
before.quot;Johnquot; gt; wrote in message
...
gt; All of a sudden some of my new formulas are appearing as the cell content
gt; instead of the content being the value of the formula. Specifically, I
gt; have
gt; several report sheets that show data from a database table range
gt; referenced
gt; by cell named 'dedb' that look like:
gt;
gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),quot;__________quot;)
gt;
gt; I added a new column in my database range called tcontact and named to,
gt; but
gt; when I copy the above formula to a cell to reference the new column, it
gt; does
gt; not evaluate. It just shows:
gt;
gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),quot;__________quot;)
gt;
gt; What's going on here? I do have over 500 named ranges in my workbook, and
gt; the workbook file is around 700KB, but I wouldn't think I was running out
gt; of
gt; room or resources.
gt;
gt; Appreciate your help.
gt;
Hitting Ctl-` displays all cell formula. This isn't what is happening. My
formulas are displaying and evaluating fine until I try to change one. Then
it just displays the formula for that particular cell. If I hit ctl-z to
undo, it goes back to the unchanged formula which works fine. It is like
something has gotten corrupted in my workbook.

quot;Vasant Nanavatiquot; wrote:

gt; Hit Ctrl ` (the key to the left of quot;1quot;). You probably hit it by mistake
gt; before.
gt;
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt; All of a sudden some of my new formulas are appearing as the cell content
gt; gt; instead of the content being the value of the formula. Specifically, I
gt; gt; have
gt; gt; several report sheets that show data from a database table range
gt; gt; referenced
gt; gt; by cell named 'dedb' that look like:
gt; gt;
gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),quot;__________quot;)
gt; gt;
gt; gt; I added a new column in my database range called tcontact and named to,
gt; gt; but
gt; gt; when I copy the above formula to a cell to reference the new column, it
gt; gt; does
gt; gt; not evaluate. It just shows:
gt; gt;
gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),quot;__________quot;)
gt; gt;
gt; gt; What's going on here? I do have over 500 named ranges in my workbook, and
gt; gt; the workbook file is around 700KB, but I wouldn't think I was running out
gt; gt; of
gt; gt; room or resources.
gt; gt;
gt; gt; Appreciate your help.
gt; gt;
gt;
gt;
gt;

Maybe you should copy all information to a new workbook.
If not try this. First make sure that none of the cells with formulas are
formatted as text, if that is the case change to
general or numbers, secondly after you have changed the formula do an
editgt;replace and replace equal sign with equal sign. However if this has
happened lately you might want to copy all data to a new workbook in case it
is getting corrupted

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Johnquot; gt; wrote in message
...
gt; Hitting Ctl-` displays all cell formula. This isn't what is happening. My
gt; formulas are displaying and evaluating fine until I try to change one.
gt; Then
gt; it just displays the formula for that particular cell. If I hit ctl-z to
gt; undo, it goes back to the unchanged formula which works fine. It is like
gt; something has gotten corrupted in my workbook.
gt;
gt; quot;Vasant Nanavatiquot; wrote:
gt;
gt;gt; Hit Ctrl ` (the key to the left of quot;1quot;). You probably hit it by mistake
gt;gt; before.
gt;gt;
gt;gt;
gt;gt; quot;Johnquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; All of a sudden some of my new formulas are appearing as the cell
gt;gt; gt; content
gt;gt; gt; instead of the content being the value of the formula. Specifically, I
gt;gt; gt; have
gt;gt; gt; several report sheets that show data from a database table range
gt;gt; gt; referenced
gt;gt; gt; by cell named 'dedb' that look like:
gt;gt; gt;
gt;gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),quot;__________quot;)
gt;gt; gt;
gt;gt; gt; I added a new column in my database range called tcontact and named to,
gt;gt; gt; but
gt;gt; gt; when I copy the above formula to a cell to reference the new column, it
gt;gt; gt; does
gt;gt; gt; not evaluate. It just shows:
gt;gt; gt;
gt;gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),quot;__________quot;)
gt;gt; gt;
gt;gt; gt; What's going on here? I do have over 500 named ranges in my workbook,
gt;gt; gt; and
gt;gt; gt; the workbook file is around 700KB, but I wouldn't think I was running
gt;gt; gt; out
gt;gt; gt; of
gt;gt; gt; room or resources.
gt;gt; gt;
gt;gt; gt; Appreciate your help.
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;Peo, you nailed it! Your the Man!! These cells were formated as text. As soon
as changed them to general, everything started working again. Is the an
Excel quot;Featurequot;? Seems strange to me.

Thank you so much. -John

quot;Peo Sjoblomquot; wrote:

gt; Maybe you should copy all information to a new workbook.
gt; If not try this. First make sure that none of the cells with formulas are
gt; formatted as text, if that is the case change to
gt; general or numbers, secondly after you have changed the formula do an
gt; editgt;replace and replace equal sign with equal sign. However if this has
gt; happened lately you might want to copy all data to a new workbook in case it
gt; is getting corrupted
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Johnquot; gt; wrote in message
gt; ...
gt; gt; Hitting Ctl-` displays all cell formula. This isn't what is happening. My
gt; gt; formulas are displaying and evaluating fine until I try to change one.
gt; gt; Then
gt; gt; it just displays the formula for that particular cell. If I hit ctl-z to
gt; gt; undo, it goes back to the unchanged formula which works fine. It is like
gt; gt; something has gotten corrupted in my workbook.
gt; gt;
gt; gt; quot;Vasant Nanavatiquot; wrote:
gt; gt;
gt; gt;gt; Hit Ctrl ` (the key to the left of quot;1quot;). You probably hit it by mistake
gt; gt;gt; before.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Johnquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; All of a sudden some of my new formulas are appearing as the cell
gt; gt;gt; gt; content
gt; gt;gt; gt; instead of the content being the value of the formula. Specifically, I
gt; gt;gt; gt; have
gt; gt;gt; gt; several report sheets that show data from a database table range
gt; gt;gt; gt; referenced
gt; gt;gt; gt; by cell named 'dedb' that look like:
gt; gt;gt; gt;
gt; gt;gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(contact), FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(co ntact),FALSE),quot;__________quot;)
gt; gt;gt; gt;
gt; gt;gt; gt; I added a new column in my database range called tcontact and named to,
gt; gt;gt; gt; but
gt; gt;gt; gt; when I copy the above formula to a cell to reference the new column, it
gt; gt;gt; gt; does
gt; gt;gt; gt; not evaluate. It just shows:
gt; gt;gt; gt;
gt; gt;gt; gt; =IF(VLOOKUP(dewono,INDIRECT(dedb),COLUMN(tcontact) ,FALSE)lt;gt;quot;quot;,VLOOKUP(dewono,INDIRECT(dedb),COLUMN(t contact),FALSE),quot;__________quot;)
gt; gt;gt; gt;
gt; gt;gt; gt; What's going on here? I do have over 500 named ranges in my workbook,
gt; gt;gt; gt; and
gt; gt;gt; gt; the workbook file is around 700KB, but I wouldn't think I was running
gt; gt;gt; gt; out
gt; gt;gt; gt; of
gt; gt;gt; gt; room or resources.
gt; gt;gt; gt;
gt; gt;gt; gt; Appreciate your help.
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;