View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Jost John Jost is offline
external usenet poster
 
Posts: 12
Default MS-Query / Excel problem

Ive got a very strange problem. I have a workbook (workflowsummary.xls)
that runs a query ((MSQRY32.EXE) against a workbook (Workflow.xls). The data
in the workflow.xls is contained in a named range €śRangeAllData€ť and is
created daily from an external program that exports to Excel format.

This daily update has worked for weeks without a problem, and there have
been no changes to the query. However starting last week, the query updates
all but one column; €śNeed Air€ť. This column contains either blanks or a
numeric value and I can not query this column or preview the information in
it. I get no data and nothing to preview, even though there is data in the
column. I can not create a new query or open an existing query that shows
any of the values that ARE there. Ive tried rearranging the data column
order (total of 46 columns)

Any ideas on what may be wrong and what I can do to fix this?