Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to read file
I am having a problem linking one workbook to another. Let me lay it
out... I have a database that runs a query and then uses a macro to "Output to" the query results to a excel file called CARQuery.xls. Once that is done A user can then open a different excel file that links to CARQuery.xls takes its data and oganizes it So a Chart can use it. The Query works fine, the Output to works fine, but when I open the second excel file with the chart it tells me "unable to read file" and then doesn't update. It does update when I have both excel files open at the same time. But either way it should update, right? FYI the db and two excel files are in the same folder on a network drive. Any help or hints would be helpful. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Read File | Links and Linking in Excel | |||
Unable to Read File | Excel Discussion (Misc queries) | |||
unable to read file | Excel Discussion (Misc queries) | |||
Unable to create any link/hyperlinks in a particular excel file | Excel Discussion (Misc queries) | |||
Unable to read file | Setting up and Configuration of Excel |