T
Troy Montour
Hello,
Adding import query on the second worksheet.
I'm getting weird results in excel 2003 when I
Select import from external data.
select excel file.
Point back to it self.
then grab the first work sheet. then I select my columns I want.
Example SiteId,receiving,updating and status
then I set my filters
receiving - Is Null
Status - Not equal to CD AND CD(Tele)
Then sort by SiteID Asc
but what its doing is pulling nothing.
I have even tried putting
receiving - not equal to x
Status - Not equal to CD AND CD(Tele)
and still nothing. this works on ever column but that one. I have tried
making new document and still nothing.
to me, it seems like a bug in 2003.
cause it should be pulling around 20 sites either way.
if I switch the filter to receiving equals x
it pulls all the ones equal to x just fine.
Thanks in advance for any help on this
Adding import query on the second worksheet.
I'm getting weird results in excel 2003 when I
Select import from external data.
select excel file.
Point back to it self.
then grab the first work sheet. then I select my columns I want.
Example SiteId,receiving,updating and status
then I set my filters
receiving - Is Null
Status - Not equal to CD AND CD(Tele)
Then sort by SiteID Asc
but what its doing is pulling nothing.
I have even tried putting
receiving - not equal to x
Status - Not equal to CD AND CD(Tele)
and still nothing. this works on ever column but that one. I have tried
making new document and still nothing.
to me, it seems like a bug in 2003.
cause it should be pulling around 20 sites either way.
if I switch the filter to receiving equals x
it pulls all the ones equal to x just fine.
Thanks in advance for any help on this