MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SQL request returning #N/A

Posted by Ann on July 13, 2001 5:56 AM

If a SQL request returns #N/A in all cells, does it mean it can't connect, or that the request is wrong?


Posted by Kevin James on July 13, 2001 6:14 AM


Do you have your Excel helpfiles installed? If so, both the question your asked about SUMIF and this question could have been quickly answered by checking the help system.

#NA, as a message from Excel, means that no value is available.


Posted by Ann on July 13, 2001 6:29 AM

I couldn't find what I was looking for in the Help files. Sorry if I wasted your time, but I'm new at this, in case you hadn't guessed.