Linked Excel Spreadsheet not updating from form in Access...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a linked Excel97 spreadsheet entitled 2004. Using Linked Table
Manager, I linked it into an Access97 Database. I've created a form to use in
the Database that opens the spreadsheet recordset with the argument,
acFormAdd, but any entry in the form doesn't carry down to the linked
spreadsheet. The record changes in the database, but doesn't carry down to
the spreadsheet. If, however, I open the spreadsheet directly, add a record,
and then open the database, the database recordset is correct. Why the
one-way linkeage on the table? Any ideas?

The private function that opens the form works correctly and all the records
are there, it even lets me add a new record, it just doesn't add it to the
linked spreadsheet.....

Thanks for any help...
 
I came across the same thing a few years ago with linked XLS tables and
embedded charts. I found that the only way I could get them to update was
to open a hidden instance of the spreadsheet. It seems pointless I know but
it worked.
 
Does anybody know the solution for this problem?
I have a very similar problem. When I make changes on the form, it not only
doesn't carry them to Excel, but also
causes error so that I can't open the form or the Excel spread sheet.
I use Access 2000 and Excel 200.

Thanks,

Janice
 
Add a button to refresh the form.

Janice said:
Does anybody know the solution for this problem?
I have a very similar problem. When I make changes on the form, it not only
doesn't carry them to Excel, but also
causes error so that I can't open the form or the Excel spread sheet.
I use Access 2000 and Excel 200.

Thanks,

Janice

use
Click to expand...
 
Galdor
When I tried this in an example I had to refresh the form to get the data to
go past the recordset and back into the excel spread sheet. I then put a
button on the form to do this. It was easy using the button tool, I think.
Tom
 
Galdor
I tried it again with the spread sheet open and then closed it made no
difference. Could you check the linked table manager to be sure you are
linked to the file that you think you are looking at?
Other that that I have no ideas at this time.
Tom
 
Back
Top