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

[Daniel]

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]

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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[Daniel]

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]

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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk