Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 , "Indigo Boy" <Indigo 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel won't calculate my formulas correctly. | Excel Worksheet Functions | |||
how can i calculate formulas automatically | Excel Discussion (Misc queries) | |||
Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
Calculate formulas with feet & inches | Excel Worksheet Functions |