Saving Notes Query in Excel

[SteveWindsor]

Anyone help here ??

I've been using Notes SQL for sometime to import data into Excel using very simple queries in MS Query. These work brilliantly all the time.

I am now setting up some new queries into other databases, but have a problem. The queries run fine and return the data, then when you save the file there's an option in Excel to save the query definitions in the Excel file, which means you don't have to select and load the query every time you run it - you 'refresh data' and the query runs.

Problem is when I try and save the new files with the Query Definitions, my processor goes flat out and the file won't save - I have to close the file with Task Manager.

Anyone know why the new files won't save ? The old files with the definitions save perfectly every time....