Excel 2003->Import External Data->Edit Query (Grayed out)

ReneGe
ReneGe used Ask the Experts™
on
Hi there,

I have an Excel 2003 file that is connected to a database through ODBC. I need to modify the query but "Import External Data->Edit Query" is grayed out.

Thanks for your help,
Rene
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Can you chechk which one are the rights that you have over the book or Sheet? Looks like a problem on rights also try to get the top cell that display the data and right clicked to see if give you the option to edit the data
If you right clicked on the data in the excel sheet (not the cell that is referencing the data that your pulling) will give you the option the edit the query

Author

Commented:
Thanks for your prompt reply.

There are no restrictions on this Excel file, sheet, cell, ect..., and I have NTFS Full Control.

If you refer to the ability of "editing the data" by changing cells = Yes I can.

Thanks,
Rene

Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
When I right click on a data field, from which the info is imported by the query, I don't get any option to edit the data.

However, I can left click on the call and by simply selecting it, I can change it's content.

Author

Commented:
... However, I can left click on a cell and by simply selecting it, I can change it's content.

Author

Commented:
I'll need a step by step procedure cause I'm kind of lost here.

Thanks
Ok, letts see; you will have to cell
A1 that is referencing the data from another cell that is conected to the database for example
A1=R5

R5 is the cell that is displaying the data conected to the database and have the conection
R5=135.25 (This value is getting from the database)

If you right click on the cell R5 you will see the option Edit Query and then you can modify your query. I'll attach some images and you will be seen better

Author

Commented:
k-designers

The problem is that I don't know what cell is connected to the database.

So, I finally resolved the issue by clicking "alt"+"shift"+"F11".

A XML looking window appeared. I changed the required text (MySQL IP address) and the problem is now resolved.

So we will not need to work more on this.

Your help was very appreciated. Thanks a million.

Cheers,
Rene

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial