Link Excel - Cannot Edit

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: GRayL (anonymous_at_discussions.microsoft.com)
Date: 02/07/04 

Date: Sat, 7 Feb 2004 12:44:29 -0800

Ste: When Access links to data in an Excel spread***,
it generates the Access table using only values. For
example, if you had an Excel spread *** with the
numbers 1-9 in a column, and a sum function at the
bottom, it would show 45. The linked table in Access
would show the a field with rows 1-9 and a 10th row of
45. You may change any of the numbers 1-9 however it will
not be reflected in the sum unless the Excel is running
that *** at the same time. You can never change the row
containing the sum function at any time as this would
change the function of the Excel ***. In other words,
you can use Access to modify Excel data, but not any
cells which contain a function.

Hope this helps, Ray

>-----Original Message-----
>i wondered if anyone could help?
>
>I have an Access database in which I use 4 linked tables
>(which are linked to Excel spreadsheets). I have a
query
>pointing to two of the spreadsheets and a normal table.
>The problem I have is that I cannot edit or add to the
>data stored in the access table. Does anyone know the
>problem?
>
>Ste
>..
>
>.
>

Quantcast