get external data not working

office 2000
i installed all the options for excel query, at least thought i did
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


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

0 Replies

Similar Articles

[PageSpeed] 7


Similar Artilces:

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

Outlook and message rules- can't get one to work?
I have set up message rules to divert mail from my inbox to various sub folders or new folders. I use these:- Check messages when they arrive\ from people or distribution list \ with specific words in the senders address \ with specific words in the subject or body Now the problem is that some of the messages are recieved from people in my address book and when they send a message sometimes their name and address is in the 'from' and other times it is just their name and so the ones with just their name do not get moved across to the folder I want. I have added their name or...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

Deleting Actual Work Deletes Protected Actuals
I am running Project Server 2007 with SP2 and Feb 2010 CU. I am using the Task Setting Restrict Updates to PWA. However, when I delete all the Actual Work for a resource in Project Pro, clicking Sync to Protected Actuals does nothing. In addition, all the hours entered via My Tasks of PWA are gone. Has anyone else experienced this bug? Hi Andrew, Is your Project Professional client also running SP2 + CU? I have seen what you mentioned but it was a bug that affected SP1 and I'm pretty sure it was fixed before SP2... Specifically the bug I recall was that it was possibl...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <> wrote in message > GP Ver 6.0. Recently I...

Getting a filename into VBA and putting it into cells
Basically what I have is a button that creates a new column that should be full of linked values. When the user hits the button, he is asked to select a file from his hard-drive; the code then takes the name of that file and creates a number of links in the new column. So for example: 1) User hits button and selects the closed excel file C:\Tempfiles\Testsheet.xls 2) Excel creates the new column and populates it with formulas that link to the file; in A1 it enters ='C:\Tempfiles\[Testsheet.xls]Overview'!$A$1 in A2 it enters ='C:\Tempfiles\[Testsheet.xls]Budget'...

I deleted a tab in OneNote, is there some way to get it back?!
I'm using Microsoft Office OneNote 2007. I had a tab that I wanted to delete, but I accidently deleted the wrong one! I didn't notice until several minutes later after messing around in O.N. some more. After I freaked out, I click the undo button. A lot. But eventually the button went gray and wouldn't let me undo any more things. And still* didn't get my tab back. Is there some way to get it back?! Pleassseeeee help! EggHeadCafe - Software Developer Portal of Choice Essential ASP.NET With Examples in C#

Auto-Calculation Not Working
I have a workbook in Excel 2003 that I update frequently. Occasionally, the workbook will not update formula results after a variable or data has been changed. Auto-calc is selected on each sheet. Pressing F9 does not do anything. I have to press F2 on each cell and then press <enter> to get the cells to update individually (quite a chore). I have not observed any common issues when this occurs. Does anyone know a fix for this? Try pressing CTRL+ALT+F9. If that doesn't work, you can always use search and replace to search for an equal sign and replace it with an equaL sig...

Where could I get flexi-arrows?
Hello, I am newbie in Visio 2003, but need to draw some diagrams. I don't find flexi-arrows (no connectors, just arrows that have to be flexible and circular shape, starting and ending at any point). It seems that MS default Visio stencils don't come with that kind of arrows. Where could I donwload or find this kind of shapes? Thanks! ...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

Getting Windows Installer error message when starting Office appli
When I start an Office application I initially get a "Windows Installer" window to pop up stating "Preparing to install...". Approximately 30 seconds or so later a window pops up titled "Problem with Shortcut". The statement in this window is "This update package could not be opened. Verify that the update package exists and that you can access it, or contact the application vendor to verify this is a valid Windows Installer update package." I am running Vista and Office 2007. This has not been a problem in the past. It appears a recent...

Outlook 2002 was working fine but now will not reply, get relay er
Outlook 2002 was working fine. Switched to DSL and now we can not reply to some addresses. Using MSN Premium for an ISP. Any help would be appreciated. Qwest techs will not support Outlook. ...

UCE content filter not working
We are running Exchange 2003 with SP2 and I'm trying to get the uce content filter to work. Below is the xml file which I do save as unicode. I can't get the Inside Elderhealth part to work. I restarted the SMPT server in Exchange System Center and the SMTP service from Services. <?xml version="1.0" encoding="UTF-16"?> <CustomWeightEntries xmlns="http//"> <CustomWeightEntry Type="Both" Change="9" Text="viagra"/> <CustomWeightEntry Type="Both" Change=...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Wnat to change email address of Public Folder email address with Exchange 2003! Get error
The HTTP service used by Public Folder is not avialable, possible are that the Public stores are not mounted and the Information Store service i snot running. Id no: c1030af Exchange System Manager Used as part of SBS 2K3 Publick folders and information services are started and working properly! Questions? 1) How to fix Public stores are not mounted? How? 2) Fixed with Exchange SP1 "Walt Smith" <> wrote in message news:z0Nqe.59554$ > The HTTP service used by Public Folder is not avialable, possible ...

Access 2007 date function not working
I had a database in Access 2003 that I imported into 2007 and all works well except the date function in Reports. I have tried to go into reports and repair by adding a date field, but when I try to open the report and error box comes up asks for update parameter value for the date. The currrent date will not display in my reports, just (#name?) is in the date field. You would think trying to put the current date in a report would be easy. -- Thanks, Mark Use this --- =Date() -- KARL DEWEY Build a little - Test a little "Mark K" wrote: > I had a database in Access ...

Outlook 20003 stopped working
Hi, As of 3 days ago, my outlook suddenly stopped working. Nothing had changed on my computer during these days. This probolems happens on 2 computers I have here, bit have the same setup and same hardware. 1. My laptop still works, I can login to all my accounts and get emails into outlook and outlook express, I can also login to msn messenger. So therefrore this is not an ISP issue. 2. I dont have a bad header or big attachement on any of the emails I am trying to download right now. I have just send some basic plain text messeges test messages. with outlook its starts to downl...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile:

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

Getting row reference number
Kindly advise me how to get the row reference number of data which VLOOKUP function fetches. Thanks If you use the MATCH function, instead of the VLOOKUP function, it returns the row_index of the searched range. Example: if you have A, B, C in cells A11:A13 and you use =MATCH("C",A11:A13,1) that formula will return 3 (because A is the 3rd item in the list. To get the actual row number, use: =MATCH("C",A11:A13,1)+10 (because you need to add in the number of rows above cell A11) Does that help? *********** Regards, Ron "Mahendhra" wrote: > Kindly ad...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

Enter month, get the first date
Hi, I want to be able to select the month from the drop down list and once the month is selected, I want the first date cell to change itself to the first date of the month selected. For rest of the date cells I have just used the formula "First date cell + 1" any help will be appreciated!! Thanks a lot in advance. Check your other post. Gaurav wrote: > > Hi, > > I want to be able to select the month from the drop down list and once the > month is selected, I want the first date cell to change itself to the first > date of the month ...

tab order not working
Hi, I've added about 5 custom fields in the Quote form and defined a tab order using the tabIndex property for all the fields in the form. However, while this order works for one section, its not working for the other section....i checked the source(through view source) on the crm form and realised that crm is enforcing its own tab order(which is quite haphazard!) despite the javascript code written on form load... Any solutions....please help!! Best option is to work within CRM's constraints. Use sections to set your tab order. For instance, if you want the tab order to go l...