| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lost query definition | Excel Discussion (Misc queries) | |||
| External Query Definition Disappears | Links and Linking in Excel | |||
| How to update ORACLE query definition in Excel file | Links and Linking in Excel | |||
| Linked files - Caching of data | Excel Discussion (Misc queries) | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
Linear Mode
