Article ID: 199140
Article Last Modified on 7/14/2004
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q199140
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
When you are viewing a linked Microsoft Excel table, you see #Error in all of the data fields.
If you try to edit the table at this point, you receive the following error
message:
The connection for viewing your linked Microsoft Excel worksheet was lost.
CAUSE
The spreadsheet was closed in Excel, and Microsoft Access lost its established link to the spreadsheet.
RESOLUTION
To re-establish the link to the Excel spreadsheet, close and reopen the
linked table in Access.
REFERENCES
For more information about linking to a Microsoft Excel spreadsheet, click Microsoft Access Help on the
Help menu, type spreadsheets, importing or linking in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
Keywords: kberrmsg kbinterop kbprb KB199140