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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 26 Feb 2008 18:15 GMT

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

Reply to this Message

Nick Hodge - 27 Feb 2008 08:29 GMT

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?

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> Hi excel expert
>
[quoted text clipped - 12 lines]
> Thanks
> Daniel

Reply to this Message

Daniel - 27 Feb 2008 12:50 GMT

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

> Daniel
>
[quoted text clipped - 18 lines]
> > Thanks
> > Daniel

Reply to this Message

Nick Hodge - 28 Feb 2008 08:40 GMT

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)

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

> hi
> At the excel 2003 tool bar whem I hit 'data' and choose 'import external
[quoted text clipped - 31 lines]
>> > Thanks
>> > Daniel

Reply to this Message

Rate this thread: