Skip to Content
Oct 25, 2007 at 09:20 AM

How to (simply) change the query embedded in a workbook?


Previously (in v 3.x), having opened workbook, select Query, -> Change Query Global -> Save As (or Open new query) -> Run.

This process embedded the new/revised query in the same workbook, which could then be saved as a new workbook with identical formatting to the first, an efficient technique which I have recently used for creating 130 queries, each with its own workbook and broadcast setting.

When I attempt to do the same in version 7 I get an error telling me that 'the requested query does not exist on the current server', even though I had just saved it.

Any ideas, please?