In Excel 2007, I have a tables linked from Access 2007. I frequently delete and import a new set of data into Access, then refresh the Excel file. Most of the time this works, but I've noticed sometimes one column doesn't refresh (even though I can see it in Access). If I modify the field name in the Access query, then refresh the table in Excel the newly named field is added in the in the last column of the table with current data. The column that wasn't refreshing stays the same.
When I originally created the link in Excel, I added various columns with formulas, but do not edit the columns that are imported from Access.
Any suggestions would be greatly appreciated! I don't know VB code or macros very well. I'm hoping to understand how this is happening so I can avoid it.
Thanks!
When I originally created the link in Excel, I added various columns with formulas, but do not edit the columns that are imported from Access.
Any suggestions would be greatly appreciated! I don't know VB code or macros very well. I'm hoping to understand how this is happening so I can avoid it.
Thanks!