Excel + MS Query + table definition caching
 

Hi

I have a number of SQL driven reports based on an 'old' table defintion. I
have since updated the back-end data and as such the field properties have
changed (length etc). When I try and run old reports they fail; new reports
work just fine.

My question is: does Excel 'cached' table property information and if so is
there a way of updating/resfreshing it WITHOUT having to recreate the report?

Thanks

Tony