Through Access can't update links to Excel with new service pack

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

Guest

I just updated with the latest service pack for Office. I have always been
able to link to Excel files and could update from Access the linked table
from Excel. But since the latest update Microsoft will not allow me to
update. Does anyone know what was set or will I have to remove the service
pack? Please advise.
 
You don't say which version of Office, but these updates disabled the
ability to update linked EXCEL spreadsheets:

Office XP
KB904018, dated October 18, 2005. See
http://support.microsoft.com/kb/904018

Office 2003
SP2. See http://support.microsoft.com/kb/904953/en-us

This feature has been disabled for legal reasons. Microsoft's own words:
"Because of legal issues, Microsoft has disabled the functionality in Access
2003 and in Access 2002 that let users change the data in linked tables that
point to a range in an Excel workbook."

Microsoft lost a legal case involving a person who claimed a patent on the
feature.
 
Back
Top