formulas won't calculate

Hello, as a preface; the calculate option in Tools is set on automatic

I built a large spreadsheet six weeks ago that has worked perfectly until
today. the sheets that contain VLookup formulas that reference data in
adjacent sheets.

The cells with the VLookup's won't claculate unless i place the cursor into
the cell (as if to edit the formula) and hit the enter key. then the formula
works, but only that cell. F9 does nothing. Restarting does nothing.

Does anyone have any ideas?

Your values are Text values rather than numbers. This often happens if
one pastes values into the workbook, especially from the web.

To coerce the text values to numbers, copy an empty cell, then select
your text numbers and choose Edit/Paste Special, selecting the values
and add radio buttons.


In article <539F756C-A4D6-4BB4-913E-77050502F7A7@microsoft.com>,
"Indigo Boy" <Indigo Boy@discussions.microsoft.com> wrote:

> Hello, as a preface; the calculate option in Tools is set on automatic
>
> I built a large spreadsheet six weeks ago that has worked perfectly until
> today. the sheets that contain VLookup formulas that reference data in
> adjacent sheets.
>
> The cells with the VLookup's won't claculate unless i place the cursor into
> the cell (as if to edit the formula) and hit the enter key. then the formula
> works, but only that cell. F9 does nothing. Restarting does nothing.
>
> Does anyone have any ideas?