"Ken" wrote:

On Jul 16, 3:34 am, mr-tom wrote:
Hi,

I have a love-hate relationship with Excel 2007.

One of the things I hate is that they seem to have neutered the connectivity.

I eventually worked out how to get to MS Query in order to create a database
query which I could update, but it seems that two critical functions are
missing.

In the past, when you right clicked, as well as "refresh", which is still
present, you also had "Data Range Properties", where you could choose when
the query would refresh, how it affected formulas etc, and you had "Edit
Query" or something to that effect, which would take you back to the query
editor.

Both of these options have been removed and I can't for the life of me find
them in the noddy ribbon bar.

If anybody knows where they've hidden these (or can confirm their removal),
you will have my eternal gratitude.

And you'll have saved Excel 2007 from an untimely uninstall.

I had the same problem today. It looks like those two options still
exist in a different place.
1. Click on "Design"
2. Click on "Refresh
3. Click on the drop-down arrow below "Refresh"
4. Click on "Connection Properties"
5. Click on "Definition" tab
Then, you should see what you are looking for.
It was easier in Excel 2003...




Good God.

No wonder I didn't find it.

Seems somewhat oblique.

Clearly another triumph for the "naturally intuitive" © ® „¢ interface.