Update Linked Excel Datasheets within Access 2010

[Matze0710]

Hello guys,

How can I update an Linked Excel Datasheet in Access 2010. When I link the Excel document in Access it won't update the Excel document. How can I update this?

Best regards

thanks in advance



Matthias

[CJ_London]

When I link the Excel document in Access it won't update the Excel document

It won't

See this link which explains why and what you need to do to 'get round it' - which is basically save as another excel file

https://support.microsoft.com/en-us/kb/904953