Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query in Excel 2007
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query in Excel 2007
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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query in Excel 2007
"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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query in Excel 2007
I have a problem in this same area that I'm hoping someone can assist with.
I am trying to us MS Query to access a MYSQL database which I am able to bring into my excel file, but then I am trying to read that file to create mailing labels and it is not working. Any ideas what the issue might be? "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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using MS Query in Excel 2007
Hi Sharon,
Sorry - no experience of mysql myself so unable to help. Since I marked the thread solved, it is unlikely that any "problem solvers" are going to read it. Your best bet is probably to create a unique thread for it so that it draws some attention. Hope this helps (although I know it doesn't help much!) Tom. "sharon Swendner" wrote: I have a problem in this same area that I'm hoping someone can assist with. I am trying to us MS Query to access a MYSQL database which I am able to bring into my excel file, but then I am trying to read that file to create mailing labels and it is not working. Any ideas what the issue might be? "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL query in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
Web Query in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) |