ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Tool bar: Data/Import external data/New database query (https://www.excelbanter.com/setting-up-configuration-excel/177930-tool-bar-data-import-external-data-new-database-query.html)

Daniel

Tool bar: Data/Import external data/New database query
 
Hi excel expert

I had this setup at my tool bar before
Data/Import external data/New database query

Now When I want to write a new query I can not access, all I have is

Data/Import external data/New

Don't know why I can not access 'new database query' as before

may be I changed excel local setup?

Need your help
Thanks
Daniel


Nick Hodge[_2_]

Tool bar: Data/Import external data/New database query
 
Daniel

Try an explain the issue more clearly as I am not sure what the difference
is. What version of Excel do you have? Is it a menu option missing
completely?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"Daniel" wrote in message
...
Hi excel expert

I had this setup at my tool bar before
Data/Import external data/New database query

Now When I want to write a new query I can not access, all I have is

Data/Import external data/New

Don't know why I can not access 'new database query' as before

may be I changed excel local setup?

Need your help
Thanks
Daniel


Daniel

Tool bar: Data/Import external data/New database query
 
hi
At the excel 2003 tool bar whem I hit 'data' and choose 'import external data'
normally I have some options of drop down menu: new database query/new web
query/edit query/parameters/ range properties

Now I don't have that any more, all the option of drop dow menu is 'new'

Thanks for your help

daniel
"Nick Hodge" wrote:

Daniel

Try an explain the issue more clearly as I am not sure what the difference
is. What version of Excel do you have? Is it a menu option missing
completely?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"Daniel" wrote in message
...
Hi excel expert

I had this setup at my tool bar before
Data/Import external data/New database query

Now When I want to write a new query I can not access, all I have is

Data/Import external data/New

Don't know why I can not access 'new database query' as before

may be I changed excel local setup?

Need your help
Thanks
Daniel


Nick Hodge[_2_]

Tool bar: Data/Import external data/New database query
 
Daniel

Try right clicking on any toolbar and selecting 'customize...' select
Toolbars tab and then Worksheet menu bar from the list. Hit Reset... and
Yes. (All customisations will be lost)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"Daniel" wrote in message
...
hi
At the excel 2003 tool bar whem I hit 'data' and choose 'import external
data'
normally I have some options of drop down menu: new database query/new web
query/edit query/parameters/ range properties

Now I don't have that any more, all the option of drop dow menu is 'new'

Thanks for your help

daniel
"Nick Hodge" wrote:

Daniel

Try an explain the issue more clearly as I am not sure what the
difference
is. What version of Excel do you have? Is it a menu option missing
completely?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.excelusergroup.org
web: www.nickhodge.co.uk





"Daniel" wrote in message
...
Hi excel expert

I had this setup at my tool bar before
Data/Import external data/New database query

Now When I want to write a new query I can not access, all I have is

Data/Import external data/New

Don't know why I can not access 'new database query' as before

may be I changed excel local setup?

Need your help
Thanks
Daniel



All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com