get external data not working

office 2000
i installed all the options for excel query, at least thought i did
but
when accessing get external data, the 'new web', 'new database', and 'import
text file' options
have a starlike yellow icon splashed on/over the icons for those options on
the menu, and if i select
any of them excel just hangs up, i've given it about 5 minutes but have to
end up killing excel
went to reinstall query etc, but its not really clear how to select just
that from the change/add functions
when doing a change/reinstall, it seems i would have to completely reinstall
all of office, but even with
that it doesn't give a chance to pic and chose which options to install like
when first installing??
kind of confusing
but basically just want to be able to get external data into excel


??????


0
bxtrap01 (34)
2/3/2004 8:07:35 PM
excel 39879 articles. 2 followers. Follow

0 Replies
717 Views

Similar Articles

[PageSpeed] 44

Reply:

Similar Artilces:

Data Validation Input Message Format
Good Evening All With Data Validation, and having an 'Input Message', is it possible to format this message, and resize the message pane? Help awaly greatfully received. Cheers, Mathew The font size in the list can't be changed. You can make the font appear larger if you increase the zoom setting (manually, or through code). See Debra's site for more information about Data-Validation http://www.contextures.com/xlDataVal01.html -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "mpb1" <mpb1@btopenworld.com> wrote in message news:...

Get default browser NOT by the registry
Hi group, I've been searching for a while for the "right" way to get the default program for specific protocols and file types, namely http and https protocols as well as the various htmlfile types. Everything that I come across has to do with querying the HKCR section of the registry, but this doesn't seem to be the right way of doing it. When I launch a URL on my computer, Windows performs some action to determine what program should handle that call. I assumed that there'd be an API call in Win32 or elsewhere that I could use to determine this same ...

Avoiding returning a 0 when no data in cell
I have worked out the formula I need to use (with help from someone from this group). However how do I stop it returning a 0 when no data is present in the cell? My formula: =VLOOKUP($G37,Staffing!$C:$AL,36,FALSE) Many thanks Steve =if(vlookup(...)="","",vlookup(...)) You may want to suppress the #n/a error, too: =if(iserror(vlookup(...)),"",if(vlookup(...)="","",vlookup(...))) Steve wrote: > > I have worked out the formula I need to use (with help from someone > from this group). > > However how do I stop it returnin...

Evalutation Software Error on Old data
Hello, When I attempt to open the manager connected to an old database (i.e. a copy from a backup months or years ago.), I get an error saying the evaluation copy of the software has expired, and the program shuts down. Using version 1.3.1011 Thanks, Greg Yep, The DB is older than 45 days and therefore will not let you access it. If you create a new DB you can use it. =========== "Greg Shepherd" <greg@frgusa.com> wrote in message news:%23sgkBF7VIHA.2000@TK2MSFTNGP05.phx.gbl... > Hello, > > When I attempt to open the manager connected to an old database (i.e. >...

Java script help please
hi I am trying to work with two dates on phone call entity in crm - actual start and scheduledend what i want to achieve is - set the actual start date to current date if it is null and then add 5 working days to actual start date below is the code i am using var CRM_FORM_TYPE_CREATE = 1; var CRM_FORM_TYPE_UPDATE = 2; switch (crmForm.FormType) { case CRM_FORM_TYPE_CREATE: crmForm.all.actualstart.DataValue == null crmForm.all.actualstart.DataValue = new Date(); crmForm.all.scheduledend.DataValue=dateadd("w",5,actualstart) break; case CRM_FORM_TYPE...

Password won't work
I believe I've read all the password problem posts but haven't found my answer. My new computer is running Vista, I have loaded Money 2006 Deluxe on, and when I try to open a backup file it asks for my password. I enter my password and it will not accept it. Please help - my life is in that file. -- Thanks!! Slim In microsoft.public.money, Slim in Mexico wrote: >I believe I've read all the password problem posts but haven't found my >answer. My new computer is running Vista, I have loaded Money 2006 Deluxe >on, and when I try to open a backup file it ask...

External website and Exchange server
Hi all, Happy new year and thanks for reading my post ! This is going to be the very first time I have to install SBS2008 (Std), we have a peer to peer workgroup network and as we are moving to a new office, I've decided to add a server to increase and enhance the network performance and collaboration. We have a couple of active domains, with website and email, hosted in an external company. We'd like to use Exchange to centralize the emails but we'd like to keep our websites hosted externally. Is it possible or do we have to host our own websites in our SBS2008 se...

How to get the registry data for all users
Hi, In my application, for each user some string is stored in registry( under HKEY_CURRENT_USER). This software is installed and uninstalled only by administrator. While uninstalling, I want to remove the registry entries of all users. Is there any way to access the HKEY_CURRENT_USER entries of all other users while the application is run as admin ( so that i can remove the entries). Regards, Faisal M Faisal wrote: > Hi, > > In my application, for each user some string is stored in > registry( under HKEY_CURRENT_USER). > This software is installed and uninstalled only by a...

Help! External email not going out!
We run Small Business Serve 2000. We do not use smarthosts. No outbound email is going out. Some of our users began receiving Delivery Status Notification (Delay)'s. All they say are: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. Then it gives the email address it failed delivery to. I can see that there are a ton of messages in the queue, under the Default SMTP Virtual Server. What should I look at for troubleshooting?? The only...

Move Mailbox 55 to 2003 delegate/client permissions not working
Hi Hope someone out there can help. We recently started moving mailboxes from Exchange 5.5 to Exchange 2003. What we find is that users who remain on the old system and which had permissions to certain folders of a user moved to 2003 can no longer access these resources. Now here is the strange part, on this particular 2003 user, when you remove the permissions on Outlook and recreate them the 55 user can still not access the folder. BUT, if I assign permissions to a completely diff Mbx (previously migrated to 2003) on 2003 then the 55 user can access the resources. We have many users w...

queue can receive internal mail but not external mail !!! help !!!
hi everyone!! i have CRM 3.0 installed and all is working fine. The only problem is the queue can receive the mail that send from internal BUT CAN NOT receive external mail! any way to troubleshot this as i had read some of the forum but is doesn't help. from the exchange system manager if mail send from internal is able to route to crm mail's box but if the mail is from external then it would not able to route to crm mail's box. There is no error message on the event viewer log. thank you if any one can help on this !!!! 1. CRM-Exchange Email Router installed? 2. Mail for...

dvd drive not working
I am having some trouble with my NEC 3550A DVD drive in Windows XP SP3. The drive is not visible in Explorer and cannot be accessed. The Device Manager does show the drive but informs me the driver is missing or corrupted (Code 39). I have uninstalled the DVD drive numerous times from the Device Manager and either rebooted or ran the Add Hardware Device applet. In each instance the OS finds the Plug and Play device and installs the device drivers but informs me that it couldn't do it properly. I have replaced the IDE cable and tried out a known good DVD drive as a replacement...

How do I get automatic sequential numbering when using an invoice.
Mary, have a look here, http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "MaryL" <MaryL@discussions.microsoft.com> wrote in message news:A9A96ABB-8284-46B6-8C6C-9FE2FFAA9C41@microsoft.com... > ...

Graphing daily data
I am trying to graph daily data for a month in Excel 2007 that groups like days (Saturdays, Sundays, etc) in the same series, while still showing individual values and dates. Any ideas on how to accomplish this? Use your worksheet to pull the relevant data together into a series. Do the data manipulation in your worksheet, then the chart plots the series which you have generated in the worksheet. -- David Biddulph "Fozzie" <Fozzie@discussions.microsoft.com> wrote in message news:EB004134-AD88-434C-9DAD-BFE4CB2FD058@microsoft.com... >I am trying to graph daily data f...

Pivot Table Data field
Hi, I am importing the data from Ms Access, and creating Pivot table. Pivot Table Columns Row------------------------------ | Data | Row, Data and Columns have drop down manus where you can select and unselect values. In Row and Columns when if i unselect any values in drop down menu and go back values are still there. However, With Data when i unselect any values it vanish i am unable to retrive it back. Please any one let me know if i unselect any values from the Data dropdown menu they still stay there. Regards, -- khansab143 -------------------------------------------...

SSRS 2008 get report parameters to work
I want to add report parameters to a sql server report service 2008 that has been generated by the report wizard and have the parameters work. I can get the report parametes to look like they work by doing the following: 1. select view then report data then right click parameters in the report data window. 2. I then select add parameters then enter a 'name' then enter a prompt name and then select data type. 3. I then right click on the dataset and then click dataset properties and then click on parameteres in the dataset properties window and add the parameters I w...

Extracting data and returing to colums.
I am about half way there, but I need some more help. These are web inquires that parsed out in the same colum and repeat th same way all down the page. I want to be able to use the fields as guidelines to pull the dat adjacent to it and sent to the new colum. In a way it is transposin all the data, but I need to pull all the first names of these peopl and have them align in the first colum. Same for Last name, business etc. So if the information that I have come across like this in th spreadsheet, I just want the customer infomation to move to th appropriate colums like the third example...

how do I convert Mozilla thunderbird data to outlook 2010?
Converted from an old Outlook to Mozilla Thunderbird years ago. Like new Outlook and would like to switch back. Can't seem to see a conversion utility -- Mishka I suspect you export from thunderbird to a format Outlook can import, eg csv (assuming pop mail) "Mishka" <Mishka@discussions.microsoft.com> wrote in message news:509C3250-167B-4FFF-9E07-5E5A8C625AA8@microsoft.com... > Converted from an old Outlook to Mozilla Thunderbird years ago. Like new > Outlook and would like to switch back. Can't seem to see a conversion > utility > -- >...

Scheduled delivery not working
Hi All, We set up a custom schedule under delivery options on the SMTP connector to schedule delivery of any messages over 4MB. It is set to deliver after hours to keep from maxing out our connection to the internet. Unfortunately, messages seem to be sitting there for days on end and not going at the scheduled times. I am able to manually force the connection and emails go fine. Anyone have any ideas of where to look since everything looks just hunky dory? Thanks! Mav ...

Show hours worked or Text "Day Off"
I have a spreadsheet that keeps track of hours worked during the week. The formula is =IF(OR(B23="",C23="",D23="",E23=""),"Day Off",(TEXT(B23,"h:mm AM/PM")&" - "&TEXT(C23,"h:mm AM/PM") &" "&TEXT(D23,"h:mm AM/PM")&" - "&TEXT(E23,"h:mm AM/PM"))) The columns track the In and Out times, Column B is In, Column C is Out, Column D is In, Column E is Out. This works great when there are no hours worked or there is a time in all 4 columns. It will give...

Complicated conditional formatting if numbers match across a data set..How?
Ok. Here is the setup I have. I have columns of data setup across the page. -1.5 -110 -1.5 -110 -2 -110 1.5 110 1.5 -105 2 -110 The -1.5 and -110 are in two seperate columns but together are under the Heading A., the second set of two numbers is under Heading B, etc. So each set of two columns should be considered a set together. My problem: I need some kind of query that will go across each data set and compare the numbers and highlight them in some way if they meet certain conditions. Take Heading A as a benchmark (Heading A makes up Columns A/B for example). I need Column A to c...

Data not displayed in some Public Folder items
Hello, I have a problem with some items in a Public Folder. These items are posted using a form from the Organisation Forms. A while ago we had a problem where the form stopped working (sorry I don't know the details as I was not directly involved) and a new form was created and set up to be used in the folder. The problem is that the data contained in posts to the folder prior to the new form being published do not contain any data. The posts are still there and can be opened, but no data is shown other than the sender's name and the name of the public folder. I am guessing t...

can't get outside email
can't get Outside email, Using groupwise connector. There is an error everytime an email arrives, that says message is looping. and the messages are never sent. ...

external and internal port numbers
cx Im seting up file sharing between my desktop (host cmputer) and my laptop ...I'm asked to insert external and internal port numbers. Are those the same as the ones I have entered in my email setup?? > cx Im seting up file sharing between my desktop (host cmputer) and my > laptop ..I'm asked to insert external and internal port numbers. Are > those the same as the ones I have entered in my email setup?? No. Different application. If it's the file sharing built into the operating system, you'll want to ask in a newsgroup about that OS. -- f.h. Microsoft O...

Get email from .edb file?
Hi All I have a perfectly good .edb file. However it's impossible to mount. Is there a utlity that can extract email from that flat .edb database? This is Exchange 5.5 Thank you, JB yes...look at Quest's Recovery Manager for Exchange... "Jack Black" <JackBlack@hat.com> wrote in message news:%23Eqy0kbHFHA.2132@TK2MSFTNGP14.phx.gbl... > Hi All > > I have a perfectly good .edb file. However it's impossible to mount. > > Is there a utlity that can extract email from that flat .edb database? > > This is Exchange 5.5 > > Thank you, JB &...