Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default XL97 changes filenames upon open

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3




  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default XL97 changes filenames upon open


Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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

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

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default XL97 changes filenames upon open

Thank you muchly Dave.......the problem is on my computer at work, and it's
just regular files, not Templates.......I'm off now but will surely try your
suggestions first thing Monday morning........

Thanks again,
Vaya con Dios,
Chuck, CABGx3




"Dave Peterson" wrote in message
...

Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so

you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

It sounds like windows is using New as the default action when you

doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one

will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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

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

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive

or
network, by doubleclicking in WinExplorer, the name of the file is

changed
by XL adding a 1 to the end of the filename.............then won't

"SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments

with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok

also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had

this
one before?

Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson



  #4   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default XL97 changes filenames upon open

Hi Dave............
Sorry I didn't get back yesterday, I stayed home sick with some kind of a
cold....am trying to work today but don't know if I can make it all day or
not........anyway, first thing this morning I tried the first suggestion you
offered and got errormessages saying "unregserver" and "regserver" could not
be found, and the right-click option stayed at new and I still got the 1 upon
doubleclicking the filename...........(is this maybe indicative of some
other problem if those files can't be found?)

Then I tired your second suggestion and it went beautifully! All is good
now in Excel-land.

Many many thanks to you, kind Sir.........
Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote:


Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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

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

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default XL97 changes filenames upon open

I like the first approach--less things for me to screw up.

I'd bet that you made a typo...

Either missed a space or use a backslash instead of slash.

CLR wrote:

Hi Dave............
Sorry I didn't get back yesterday, I stayed home sick with some kind of a
cold....am trying to work today but don't know if I can make it all day or
not........anyway, first thing this morning I tried the first suggestion you
offered and got errormessages saying "unregserver" and "regserver" could not
be found, and the right-click option stayed at new and I still got the 1 upon
doubleclicking the filename...........(is this maybe indicative of some
other problem if those files can't be found?)

Then I tired your second suggestion and it went beautifully! All is good
now in Excel-land.

Many many thanks to you, kind Sir.........
Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:


Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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

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

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3


--

Dave Peterson


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default XL97 changes filenames upon open

And...........right you are again!
Type-o, my bad.............both of your suggestions work fine.

Thanks again Dave........
Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote:

I like the first approach--less things for me to screw up.

I'd bet that you made a typo...

Either missed a space or use a backslash instead of slash.

CLR wrote:

Hi Dave............
Sorry I didn't get back yesterday, I stayed home sick with some kind of a
cold....am trying to work today but don't know if I can make it all day or
not........anyway, first thing this morning I tried the first suggestion you
offered and got errormessages saying "unregserver" and "regserver" could not
be found, and the right-click option stayed at new and I still got the 1 upon
doubleclicking the filename...........(is this maybe indicative of some
other problem if those files can't be found?)

Then I tired your second suggestion and it went beautifully! All is good
now in Excel-land.

Many many thanks to you, kind Sir.........
Vaya con Dios,
Chuck, CABGx3

"Dave Peterson" wrote:


Saved from a previous post:
===========================

Are you opening a template file (*.xlt) or a normal workbook file (*.xls)?

If you're opening a template file, then this is the way excel works--so you
don't overwrite that template.

If you're opening an excel file, then excel/windows is confused.

It sounds like windows is using New as the default action when you doubleclick
on the filename in windows explorer.

If you right click on a *.xls file, you'll see a bunch of options--one will be
Open and one will be New. Open should be the bold (default) one.

I bet you'll see New in bold.

If that's the case, you can try this:

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

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

Now try double clicking on that filename.

Did it work ok?

If yes, woohoo!

If no, you could manually change the default action.

Close excel
start windows explorer
tools|folder options|file types tab
scroll down to the xls extension (microsoft excel worksheet)
click the advanced button
click on the Open item in the Actions box
click set as default
(ok your way out)


CLR wrote:

Hi All...........

Just started today...........when I open any .xls file, either C drive or
network, by doubleclicking in WinExplorer, the name of the file is changed
by XL adding a 1 to the end of the filename.............then won't "SAVE"
back to where I got the file from, wants to "SAVE AS" in MyDocuments with the
new filename.............

If I open the same files by rightclick-open in WinExplorer they open
normally.............if I open XL first, the same files open ok also..........

AutoCAD and WORD files still open ok by double-clicking.

This a couple of weeks after MIS upgraded me from Win98 to
WinXP.....although it has worked ok up untill today.......anybody had this
one before?

Vaya con Dios,
Chuck, CABGx3

--

Dave Peterson


--

Dave Peterson

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
CSV formatted files open odly in Excel 2000 Janski Excel Discussion (Misc queries) 3 November 24th 05 07:58 PM
i try to open Excel spreadsheets, and they open in wordpad-- mikekeat Excel Discussion (Misc queries) 2 October 1st 05 10:13 PM
cannot open an xl97 file maxzsim Excel Discussion (Misc queries) 1 June 24th 05 12:29 PM
When I open excel document it always ask if I want to open it in . dperkins Excel Discussion (Misc queries) 0 February 15th 05 08:11 PM
Xfer of XL95 custom menus into XL97 windsurferLA Excel Worksheet Functions 2 February 1st 05 11:33 PM


All times are GMT +1. The time now is 05:12 PM.

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

About Us

"It's about Microsoft Excel"