Function displays as text, doesn't return result or error

[SK_in_Austin]

When I export data from QuickBooks to an Excel spreadsheet, the function
feature appears to be turned off. I type a correct syntax function into a
cell, preceded by an "=", formatted as "general" and with the "option"
function view turned off, and the following is displayed instead of the
result:

=VLOOKUP(D2,Sheet2!A2:B11,2)

Literaly, it just shows me what I typed. I KNOW there is a switch somewhere
that QuickBooks turned off in this workbook... For the life of me I can't
find it.

[Pete_UK]

You might have calculation mode set to manual - go to Tools | Options |
Calculation (tab) and ensure that Automatic is checked.

Hope this helps.

Pete

[SK_in_Austin]

Apparently, the cell I was referencing for the lookup value was formatted as
"text," so Excel "helpfully" auto-formatted the cells containing the
referencing functions as "text." Voila! typed formula instead of a result.

I went back and made sure that all reference cells were formatted GENERAL.
Life is good again...


"Pete_UK" wrote:

> You might have calculation mode set to manual - go to Tools | Options |
> Calculation (tab) and ensure that Automatic is checked.
>
> Hope this helps.
>
> Pete
>
>