Excel Queries

[klmorgan]

I have set a query in one workbook that Queries data in another workbook. This has been done so that a numer of sheets can look at data in the source sheet without tying it up and preventing others writing to it.

I have been experiencing difficulties where some data does not appear in the queries that exists in the data sheet, this is not whole rows of data but a number of cells.

it appears that this is like a mismatch of data types between the data sheet and the query sheet but even trying to set the formats on the cells to the same type does not seem to work.

Anyone know what the rules are with these queries?

Keith

 

[Wray69]

This Microsoft KB article gives the specs for a query, dont know if it will help you any or not.

http://support.microsoft.com/default.aspx?scid=kb;en-us;141174

Regards -

Wray

 

[xlbo]

Remeber that setting formats will NOT change data types
All formatting does is apply a mask over what is actually there.

If the data type errors are caused by text masquerading as numbers, you can test this by using =ISTEXT(a1) where A1 is a suspect cell. A TRUE result means that it is a number
to correct, use =TEXT(A1,"0&quot

If it is the other way round, you can test using =ISNUMBER(A1) and to correct use =A1*1 or =VALUE(a1)

If it is a date issue then I will need a bit more info about the actual data that exists and what data type it SHOULD be Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde