| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula errors
I have a column where all formulas are the same except row number. Some of
the formulas are returning '#N/A' when I open the file. The formulas link to another file. When I open the other file, the values update correctly. Only about a dozen blocks are doing this. All other blocks are calculating correctly before I open the source file. If I open the Error Checkingbox, it says 'A value is not available to the formula or function' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
| "Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
Threaded Mode
