Hi all

Can anybody help please?

I have several excel spreadsheets that query a SQL server database via MS Query, which up to now have been working fine.

All of a sudden occasionally and ramdomly the query returns data as text (destroying link), particularly after saving the file.

It is as if the save query definition has been unticked and the named range disappears. (as if you have done copy / paste special / values)

This has worked for years up till now and no patches or updates have been applied.

Dont think the ODBC driver is corrupt and also I get the same result if I create the query from scratch again in a new workbook.

It is not a user or PC issue as this happens to all PC's running it.

I cannot work out what it is and have had a search around the net, I have found posts of other users finding same issues but none appear to have resolved it.

PS Also seems to happen on Access Queries

Please help if you can.
Cheers
CD