Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
aj
 
Posts: n/a
Default Problem opening Excel files from Windows Explorer

Hi All,

When I go to open up and Excel file from Windows Explorer by
double-clicking it, a 1 is added to the filename. If I open the same
file from within Excel itself there is no problem. Any ideas?

Thanks

  #2   Report Post  
Rob van Gelder
 
Posts: n/a
Default

From Windows Explorer's Tools menu | Folder Options | File Types
Scroll to find XLS | Advanced
Select Open then Edit

Application used (for me running XL2003) is:
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"aj" wrote in message
oups.com...
Hi All,

When I go to open up and Excel file from Windows Explorer by
double-clicking it, a 1 is added to the filename. If I open the same
file from within Excel itself there is no problem. Any ideas?

Thanks



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

aj

This kind of thing can happen when you double click on the f*ile in windows
explorer.

From an earlier post from Dave Peterson that may help:

It sounds like the default behavior when you double click on* a .xls file is
set to NEW, not OPEN.

Try a test to verify:

Right click on the file when you're in windows explorer.

You should get a popup with a bunch of options. I get Open *and New right at
the top of the list. Open is bolded which means that Open is th*e default
action when I double click on the file.

If your default action is NEW, then windows will tell excel *to open it like a
template. That's why you'd get the myname1 (with no extensi*on).

If your situation matches, this is what I'd do next (the eas*iest, I think).

Close Excel and
Windows Start Button|Run
excel /unregserver then
Windows Start Button|Run excel /regserver

The /unregserver & /regserver stuff resets the windows regis*try to excel's
factory defaults.

Now you could check by rightclicking again. If it looks good, try double
clicking and see if it really worked!

==========
Option 2. (A little more work.)

I use windows98, so depending on your version of windows, it* might not be
quite the same--but it'll be pretty close.

Close excel
open Windows explorer (flying windows-E is a quick way)
View|Folder Options|File Types
Scroll down to Microsoft Excel Worksheet and select that
Click the Edit button
You'll see a list of Actions in a little box.
Open should be the bold one (here, too!)

If it's not, then click on Open and then click the "make def*ault" button.

(Ok your way out.)



Gord Dibben Excel MVP

On 29 Jan 2005 19:59:27 -0800, "aj" wrote:

Hi All,

When I go to open up and Excel file from Windows Explorer by
double-clicking it, a 1 is added to the filename. If I open the same
file from within Excel itself there is no problem. Any ideas?

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening DBF files with Excel 2003 via Windows Explorer ? David Purdy Setting up and Configuration of Excel 2 May 3rd 06 09:21 PM
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 2nd 05 12:31 AM
Problem opening an XML file in Excel - getting "ns1:macrosPresent" rprondeau Excel Discussion (Misc queries) 0 December 15th 04 04:39 PM
Can I import a windows explorer list of files into an Excel sprea. skeliher Excel Discussion (Misc queries) 2 December 1st 04 11:24 PM
How do I import a Windows Explorer list into Excel? Gord Dibben Excel Discussion (Misc queries) 0 December 1st 04 11:20 PM


All times are GMT +1. The time now is 10:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"