Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel linked to Access
Hi
After displaying the results of an Access query on an excel worksheet (as a linked excel object), I have moved both the Access DB and Excel worksheet to another location. The problem now is that I cannot seem to update the data on excel. I have tried to change the source in Edit Links in excel but I receive the following error: "Reference is not valid . Reference must be to an open worksheet" I am a little puzzled since I have the worksheet already open. Many thanks for your assistance. Dean Collins |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel as an actively linked workbook in Access | Excel Worksheet Functions | |||
Excel File Linked in Access | Excel Discussion (Misc queries) | |||
Excel to Access linked tables | Excel Discussion (Misc queries) | |||
New Excel data does not appear in linked Access table | Excel Discussion (Misc queries) | |||
Error Printing Excel 97 linked to access 97 on NT | Excel Discussion (Misc queries) |