ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creates new file when opening in windows explorer (https://www.excelbanter.com/excel-discussion-misc-queries/170856-creates-new-file-when-opening-windows-explorer.html)

fund_dan

Creates new file when opening in windows explorer
 
I have a user that has a wierd problem. When she selects an excel file in
Windows Explorer and opens it, it creates a duplicate file with number 1 at
the end. For example, if the file is called aplogs.xls, when you open it, the
file name is aplogs1. The user is getting macro questions as well as asking
if she wants to update. The .xls extension also goes away in the title bar.
Any thoughts?

Peo Sjoblom

Creates new file when opening in windows explorer
 
It's because this particular file is a template file *.xlt and not a *.xls
file. If you save it as xls and open that file from now on it won't happen.
I also assume it has some links to other files plus a recorded macro


--


Regards,


Peo Sjoblom


"fund_dan" wrote in message
...
I have a user that has a wierd problem. When she selects an excel file in
Windows Explorer and opens it, it creates a duplicate file with number 1
at
the end. For example, if the file is called aplogs.xls, when you open it,
the
file name is aplogs1. The user is getting macro questions as well as
asking
if she wants to update. The .xls extension also goes away in the title
bar.
Any thoughts?




fund_dan[_2_]

Creates new file when opening in windows explorer
 
The only issue is that this happens with all .xls files that she tries to
open as well as happening with other profiles.

Dan

"Peo Sjoblom" wrote:

It's because this particular file is a template file *.xlt and not a *.xls
file. If you save it as xls and open that file from now on it won't happen.
I also assume it has some links to other files plus a recorded macro


--


Regards,


Peo Sjoblom


"fund_dan" wrote in message
...
I have a user that has a wierd problem. When she selects an excel file in
Windows Explorer and opens it, it creates a duplicate file with number 1
at
the end. For example, if the file is called aplogs.xls, when you open it,
the
file name is aplogs1. The user is getting macro questions as well as
asking
if she wants to update. The .xls extension also goes away in the title
bar.
Any thoughts?





Peo Sjoblom

Creates new file when opening in windows explorer
 
Tell her to open the files in Excel via fileopen

then try either of these


toolsoptionsgeneral and deselect (if checked) "ignore other applications"


or



1. Close Microsoft Excel.

2. Click Start, and then click Run.

3. In the Open box, type the following (with the quotation marks):

"C:\Program Files\Microsoft Office\Office\Excel.exe" /unregserver

NOTE: If you have installed Microsoft Office to another location, use your
correct path for Excel.exe instead.

4. Click Start, and then click Run.

5. In the Open box, type the following (with the quotation marks):

"C:\Program Files\Microsoft Office\Office\Excel.exe" /regserver



HTH


--


Regards,


Peo Sjoblom





"fund_dan" wrote in message
...
The only issue is that this happens with all .xls files that she tries to
open as well as happening with other profiles.

Dan

"Peo Sjoblom" wrote:

It's because this particular file is a template file *.xlt and not a
*.xls
file. If you save it as xls and open that file from now on it won't
happen.
I also assume it has some links to other files plus a recorded macro


--


Regards,


Peo Sjoblom


"fund_dan" wrote in message
...
I have a user that has a wierd problem. When she selects an excel file
in
Windows Explorer and opens it, it creates a duplicate file with number
1
at
the end. For example, if the file is called aplogs.xls, when you open
it,
the
file name is aplogs1. The user is getting macro questions as well as
asking
if she wants to update. The .xls extension also goes away in the title
bar.
Any thoughts?







fund_dan[_2_]

Creates new file when opening in windows explorer
 
That second option worked. Thanks.

Dan

"Peo Sjoblom" wrote:

Tell her to open the files in Excel via fileopen

then try either of these


toolsoptionsgeneral and deselect (if checked) "ignore other applications"


or



1. Close Microsoft Excel.

2. Click Start, and then click Run.

3. In the Open box, type the following (with the quotation marks):

"C:\Program Files\Microsoft Office\Office\Excel.exe" /unregserver

NOTE: If you have installed Microsoft Office to another location, use your
correct path for Excel.exe instead.

4. Click Start, and then click Run.

5. In the Open box, type the following (with the quotation marks):

"C:\Program Files\Microsoft Office\Office\Excel.exe" /regserver



HTH


--


Regards,


Peo Sjoblom





"fund_dan" wrote in message
...
The only issue is that this happens with all .xls files that she tries to
open as well as happening with other profiles.

Dan

"Peo Sjoblom" wrote:

It's because this particular file is a template file *.xlt and not a
*.xls
file. If you save it as xls and open that file from now on it won't
happen.
I also assume it has some links to other files plus a recorded macro


--


Regards,


Peo Sjoblom


"fund_dan" wrote in message
...
I have a user that has a wierd problem. When she selects an excel file
in
Windows Explorer and opens it, it creates a duplicate file with number
1
at
the end. For example, if the file is called aplogs.xls, when you open
it,
the
file name is aplogs1. The user is getting macro questions as well as
asking
if she wants to update. The .xls extension also goes away in the title
bar.
Any thoughts?








All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com