Publish how to force Access to purge its Excel memory

W

waynemb

When I link an Excel sheet as an Access table, Access memorizes the values of
all the calculated fields. When new values are plugged into other cells the
calculated fields never change in Access. I can delete the link, close
Access, open Excel to verify that the values in the calculated fields have
indeed changed as expected; then close Excel, open Access, relink the table,
and Access always plugs in the old originally-memorized values into the
calculated fields.

The only way I've found to force Access to purge its memory and take a fresh
look is to make a structural change anywhere in the Excel file. That seems
to work every time.

I'm using Access 2003 and Excel 2000

Any way you can publish a solution for this?

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...cf69&dg=microsoft.public.access.modulesdaovba
 
Top