Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with MS Query in Excel | Excel Discussion (Misc queries) | |||
access query/excel.exe problem | Excel Programming | |||
weird problem when using MS Query from Excel | Excel Programming | |||
Excel Query - Code problem | Excel Programming | |||
Problem with .Background Query option of ODBC Query | Excel Programming |