File open from Windows Explorer fails after Get External Data

Using Excel 97, is anyone aware of a problem where, after having "got
external data" from a SQL database into a spreadsheet, an Excel file
will not open from Windows Explorer.  I receive no error messages, the
open simply does nothing.  The only way of opening files is by using
the File Open within Excel or closing Excel and re opening all files
without "getting external data" at any time.

Many thanks
Fred Newton
Zurich Financial Services
9/9/2004 4:16:49 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 57

try the following:
goto 'Tools-Options-General " and uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

1. Close Excel first and
2. On the Windows Taskbar
2.1 Start>Run "excel.exe /unregserver"(no quotes)>OK.
2.2 Start>Run "excel.exe /regserver"(no quotes)>OK.

Frank Kabel
Frankfurt, Germany

Fred Newton wrote:
> Using Excel 97, is anyone aware of a problem where, after having "got
> external data" from a SQL database into a spreadsheet, an Excel file
> will not open from Windows Explorer.  I receive no error messages,
> open simply does nothing.  The only way of opening files is by using
> the File Open within Excel or closing Excel and re opening all files
> without "getting external data" at any time.
> Many thanks
> Fred Newton
> Zurich Financial Services

frank.kabel (11126)
9/9/2004 7:11:55 PM

Similar Artilces:

UI Data Validation using XML Schema
Has anybody done UI data validation usinf XML Schemas. Any pointers will help. Thanks! ...

How to get information from the process monitor queue in GP 9.0
Hi, How to know which process exists in process monitor queue? If developer wants to know process details from process monitor queue in GP 9.0 then is there any system functions available? Constants, which are available in GP7.0 and GP 7.5 does not exists in GP 9.0. Is there any alternative option available in GP 9.0 to retrieve process queue information? Thanks ...

Get Area onload
Hello, For a new module we created, I want to create a new contactperson. At the moment when I create that new contact person, there must be one section hidden. This is no problem when I look to a security role and make it hidden. But I don't want to use a security role but I want to use the area from where the "New Contact" has been clicked (sales or the new module). So I need to get the area in an onload script and dependend of the area I want to hide a section. Can somebody help me with this on load script. Regards, Arno Schlepers There are plenty of samples foating ...

Change paths to linked external data
Hello. I have a database that has 3 external links in it: 1 is to a table in another Access Database. One is to an excel spread sheet. And, the third is to a .csv file. Is there a way in VBA to change the paths to these? Basically, i want to set up a form where the user can specify the new paths in text boxes if any of these files are moved. Anybody help me out? (Access 2007) cyb3rwolf wrote: >Hello. I have a database that has 3 external links in it: 1 is to a table >in another Access Database. One is to an excel spread sheet. And, the third >is to a .csv...

Can anyone send me the Microsoft.Crm.Platform.Proxy.dll and Microsoft.Crm.Platform.Types.dll files ?
Hi, I'm stucked without those files, and I don't have the instalation disk. Can anyone send me those files ? Thanks in advance, Eddie. You can download the program from Microsoft. Sorry-wrong group Eddie, email me and i will send them over -- John O'Donnell Microsoft CRM MVP "Eddie" <> wrote in message news:epJ2yF3NFHA.3076@tk2msftngp13.phx.gbl... > Hi, > > I'm stucked without those files...

Combo box filter before form opens
frmSearchType with cboType and cmdOpenForm which opens frmEntryEdit. frmEntryEdit uses cboEntryNum to allow user to select from the filtered records. This is working correctly, however if no records fit the filter, I get an open frmEntryEdit, with no records in the cboEntryNum. I would rather have a message box that states "No Data fits the criteria", than have frmEntry Edit open. Is this possible? -- Teach me to fish! Thanks for the help. Pax, M m stroup wrote: >frmSearchType with cboType and cmdOpenForm which opens frmEntryEdit. >frmEntryEdit use...

Bulk Import Wizard for Leads Issue
Hi, I am trying to import Lead records using a CSV file containing around 3,000 records. I have tested with around 20 records (taken from the larger file) and it imports fine but when I select the the 3,000 record file for import the wizard gives an error message somthing like (sorry don't have exact wording) 'Source Import file is corrupt'. Are there any known issues with CSV files such as the following : 1) Special characters such as an asterix not handled 2) Email and Website type fields must all be correctly formatted? 3) File is too large Thanks for your help in adva...

Something destroying Money data
My MS Money 2007 software was working fine, and then a few months ago, there were transactions missing. I went for backups, and it seemed every time I opened a MOney file there were fewer transactions--it was truly weird. Thinking a file had been accidentally deleted, I used a file recovery program and retrieved file and backup - also no data. So I just put the whole thing aside and out of mind, but tried again today and searched all partitions for mny and mbf files.. Same result, if anything fewer transactions. Is there some virus or other malware that eats Money files? I guess I can d...

How to transpose in excel file
Hi I would like to make a transpose like this? From House Defect How much #1 Broken Sinks 1000 #1 Bad Paint 2000 #1 Bad Lighting 1000 #2 Broken Sinks 0 #2 Bad Paint 2000 #2 Bad Lighting 100 and Transpose into House Broken Sinks Bad Paint Bad Lighting #1 1000 2000 1000 #2 0 2000 100 A Pivot Table will do that and more. Set House as row field, Defect as column field and How much as data. HTH. Best wishes Harald "vilfood" <vilfood@d...

XML into DataSet
Hi. I need some help. I have an xml file what will contain hundreds of groups and will have an associated xsd. My overall goal is to have a web application that allows a user to input a groupID from a webform, the application will than find that groupID in the xml file and display all the related information for that group only. I have read my xml into a DataSet and have been able to successful find groupID and display some of the information for that particular group. But I have been unable to navigate to the groupsItems node and subsequently the details of each groupItem found in gro...

MBF file won't I hosed???
In my previous computer I had a flaky hard drive. While it still worked I backed up all my important files to CD's and DVD's. Since I dutifully backed up my MNY file (to two locations) each time I used my Money 2001 I didn't think to copy my MNY file I merely copied the MBF files from those locations. Once, I had to use that an MBF file as my MNY file was corrupt and it worked flawlessly. I saw no reason why it shouldn't do so again. Plus I was in panic mode to get all the data possible from the dying HD. Now that I have a new computer I installed my copy of MM 2001 and wh...

excel file can't be opened #2
hi,I'm cho I have a recent excel file (about 1 month),but since two days ago,the file can't be opened completely or always not responding. What should I do so that I can use this important file. Any help would be appreciated regards, cho ...

Outlook 2003 attach File Browse Window Stops Responding
In outlook 2003 when I try to attach a file and the browse window pops open to browse for the file I want to attach the window will stop responding and I have to force quit the outlook. Any Ideas? do you have mapped network drives? how long do you wait before quitting outlook? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: Outlook & Exchange Solutions Center: http://www.slipsti...

Can't restor backup file, "Please insert the next backup disk.....
I have money 2005 backup file (.mbf) and my original file has gotten corrupted somehow and can't repair it (computer hung and had to be restarted). Whenever I try to restor the backup file, I get the following message, Window Title: Money Multiple Disk Backup Message: Please insert the next backup disk. (The disk containing file "".) I was backing up on a different connected single harddrive and there is only one file. The file is not in multiple pieces and on different drives. When I click OK, it doesn't do anything and cancel just stops the process. I even down...

Office 2007 and Windows 7 Multilingual Issue
Hi All, Need some help setting up multilingual for Office 2007. Here's what I have: OS: Windowns 2007 Enterprise Office: Office 2007 Pro w/ SP2 Language Pack: Install several language packs thru the Windows 7 Update process So, here's the thing. I can't get the UI in the office apps (WOrd, Excel, etc) to display the language I want. For example, I want the ribbon to display in Chinese. Reading thru the documentations from Microsoft, it saids I need to select the laugage in the "Display Language" tab on All Programs -> Microsoft Office -> M...

The easiest way to get free cash! #2
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>Hi all,</P> <P>I became a member of an interesting free website that is totally unique. It actually rewards its members for learning! You can learn lots of important things and earn rewards taking fun quizzes, plus earn cash for other activities! Membership is free, and people of all ages and educational backgrounds everywhere can become members and participate at their own level. It�s called �It P...

windows xp frontpage error
Just got a call from my child at college, is getting a message saying to "put in windows xp cd with frontpage", it was installed at the factory and the cd says nothing about frontpage, was installed in coputer in2004 windows xp professional, autoupdatw won't do it. any clue to what is going on? Is freezing computer and won't open excell. Hi Diana, Though this is the newsgroup for Microsoft Dynamics GP and not Windows XP or Ofice, I will try to help you out. In future, please post to the appropriate newsgroup. I believe the error message being received is infact askin...

Office XP on a windows 7 machine
I currently own Office Professional XP. I have to buy a new machine that will have Windows 7 as the OS. Will I still be able to install my software on this new machine w/o any issues? Or will I be forced to buy a newer version? I don't know about 32 bit vs 64 bit, Or various versions or beta's, I just want to use what I have on whatever machine I buy. Thanks Tom If no naswer here check the Win7 forum at: "Tom" <> wrote in message news:38e18fec-2219-467c-...

HowTo add row to series data
1) insert row with ShiftDown 2) apply new data to the newly emptied cells 3) preserve original chart series range 1) after this code row 2 is empty cells Excel.Worksheet chart = (Excel.Worksheet)book.Worksheets["Chart Data"]; Excel.Range rngToday = chart.get_Range("A2", "D2"); rngToday.Insert(Excel.XlInsertShiftDirection.xlShiftDown); 2) this puts todays date into A2 rngToday.NumberFormat = "MM/dd"; rngToday.Value = DateTime.Today; 3) OOPS - the chart data is now A3..A7 because of the insert above How do I reset the souce data to A...

Excel 2000 fail to open workbook
Hi, I have one Excel template. If we open it on Excel 2000, the Excel will hang, and the process occupy cpu 95% ~98%. But we can open this tempalte in Excel 2003 normally, and if we save this tempalte in Excel 2003, and then open it in Excel 2000, it work normally too. Excel 2000 (9.0.3821 SR-1) Excel 2003 (11.8231.8221) sp3 Would you help us to find the reason for this issue? Thanks, Nancy Hi Nancy, Perhaps there was some (probably minor) corruption/inconsistency in the workbook that Excel 2003 could fix but Excel 2000 couldn't. -- Cheers macropod [Microsoft MVP - Word] ...

How do you check out a file from a link
I have received a link to an excel file stored in a SharePoint library. When I open the file the option to 'check out the file' does not appear at the top of my screen. This function does work for a word document in the same library. Please can you advise. Thanks With your browser, go to the Library where the document is located and check out from there. --rms On 16/04/10 15:44, Tracey T wrote: > I have received a link to an excel file stored in a SharePoint library. When > I open the file the option to 'check out the fi...

Error by open contacts or activities after Migration to CRM 3.0
Hello, i ve migrated our CRM 1.2 System to CRM 3.0 Now I get a error-page when I open contacts or activities or so. I cannot open the main form of these entities (customizing). Any ideas? Stefan ...

Windows 7 taskbar API problems
Folks The background is that an Access MDE/ACCDE created by a developer is not conceptually the same as an Excel spreadsheet or Word document file created by the user. My Auto FE Updater utility automatically downloads any new version created by the developer from the server to the workstation as well as doing lots of other stuff such as creating shortcuts on desk tops. If this was a user created Access database file which resides in the users My Documents folder, or similar, than they are conceptually the same as a Word or Excel file. The problem is if the user right-clicks on...

how to get the system setup time.
I want to get the system setup time. but this code didn't work! CreateFile always return -1, and the error code is 0x00000005!(Access is denied.) TCHAR path[MAX_PATH]; if (GetWindowsDirectory(path, MAX_PATH)==0) break; HANDLE h = CreateFile(path, GENERIC_READ, FILE_SHARE_READ|FILE_SHARE_WRITE, NULL, OPEN_EXISTING, FILE_ATTRIBUTE_NORMAL, NULL); if (h==INVALID_HANDLE_VALUE) break; // always return Access is denied.! FILETIME ft1, ft2, ft3; if (!GetFileTime(h, &ft1, &ft2, &ft3)) break; thank you ! Buried in the MSDN documentation for the CreateFile function, there...

Can we make a document frame window title bar disapper?
Hi, friends, I registered a document template in InitInstance(). It may not be an MDI child. When I created a new document, I tried to make the frame title bar disappear by setting: = WS_DLGFRAME; in function PreCreateWindow(CREATESTRUCT& cs). Unfortunately, the title bar was still there, although no more caption. I also tried setting: &= ~WS_CAPTION; and some other combinations, no luck. Could anyone tell me how to do it? Or, can we do it? Thanks. You need to remove WS_CAPTION style. You can do it in Precreatewindow and for mainframe do it after it ha...