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

[Former Member]

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?

Thanks,

Patrick

[Former Member]

Thanks Pavel

[pavel_afanasiev]

take a look at OSS notes 1060406 and 1067102

we had to apply one of the to fix the RRI

[Former Member]

Hi

r u trying to open the query of 3.5 environment

[Former Member]

No, version 7