Linked Excel File won't update

  • Thread starter Thread starter xyzer
  • Start date Start date
X

xyzer

I have an excel file linked to a database. The excel data is updated through microsoft query from time to time. Why, after I update/refresh the spreadsheed and save it, does the Access linked file not update? Do I really have to get out and get back in?
 
I have an excel file linked to a database. The excel data is updated through microsoft query from time to time. Why, after I update/refresh the spreadsheed and save it, does the Access linked file not update? Do I really have to get out and get back in?
Click to expand...

Microsoft lost a lawsuit several years ago, and had to remove the ability to
update linked spreadsheets. STUPID software patents...

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
Back
Top