Hi,
I have an Excel (2010) spreadsheet which loads an Access (XP) query. Set up using the Excell Data Access button.
It has worked fine for 2 years and suddenly won't connect to the database for this particular query.
By a process of elimination I have found that it has stopped because of 2 calculated fields in the query. When I changed these to a fixed value the rest of the query downloaded fine.
Now I have to rewrite the formula in Excel each time I refresh the imported table which is not convenient in a multi user environment.
Any ideas why the sudden change or how I can fix it , please??
I have an Excel (2010) spreadsheet which loads an Access (XP) query. Set up using the Excell Data Access button.
It has worked fine for 2 years and suddenly won't connect to the database for this particular query.
By a process of elimination I have found that it has stopped because of 2 calculated fields in the query. When I changed these to a fixed value the rest of the query downloaded fine.
Now I have to rewrite the formula in Excel each time I refresh the imported table which is not convenient in a multi user environment.
Any ideas why the sudden change or how I can fix it , please??