I have a large number of Excel Query driven spreadsheets interrogating an AS400 database, and suddenly, for no reason anyone can establish, they are no longer editable - eg adjust a date range in the Criteria. I have been running these in Office 2003 for quite a few years without issue. This is happening on all PC's across the network.

The queries can be refreshed with no problem, but go to edit the query, and it opens up the SQL string, which whether you OK or Cancel, then only gives the data - you cannot get to pull down either the Criteria or Table tabs!

Any feedback or thoughts would be much appreciated.