ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File already open (https://www.excelbanter.com/excel-discussion-misc-queries/184492-file-already-open.html)

Nile

File already open
 
Hi,

I have installed office 2007 in Windows XP SP2. Every time i double click on
an Excel file to open it, i get the following msg

"test.xls is already open, reopening will cause any changes you made to be
discarded. Do you want to reopen"

i have searched for this and one suggestion was to register the Excel with
"excel.exe /regserver"

But this did not fix the problem.

Anyone could help with tihs?

Thanks in advance.




Jim Rech

File already open
 
I'd guess that if you went into My Computer, Tools, Folder Options, File
Types, found XLS, clicked Advanced, selected Open and clicked Edit you would
find a "%1" at the end of the "Application used..." command line. If so,
remove it and OK your way out.

--
Jim
"Nile" wrote in message
...
| Hi,
|
| I have installed office 2007 in Windows XP SP2. Every time i double click
on
| an Excel file to open it, i get the following msg
|
| "test.xls is already open, reopening will cause any changes you made to be
| discarded. Do you want to reopen"
|
| i have searched for this and one suggestion was to register the Excel with
| "excel.exe /regserver"
|
| But this did not fix the problem.
|
| Anyone could help with tihs?
|
| Thanks in advance.
|
|
|



Nile

File already open
 
Hi Jim,

Thanks for the reply.

i tried to delete the "%1" but it doese not delete. i clicked ok on the
windows but when i open it agin it is still there. I am an administrator on
this PC but ye cannot delete, not sure how to delete it.

I added the "%1" as it was recommended in one website to overcome a delay
problem. Excel used to take 1-2 mins to open a file so i added the "%1" which
fixed the delay.

Could you help more?

Thanks,

"Jim Rech" wrote:

I'd guess that if you went into My Computer, Tools, Folder Options, File
Types, found XLS, clicked Advanced, selected Open and clicked Edit you would
find a "%1" at the end of the "Application used..." command line. If so,
remove it and OK your way out.

--
Jim
"Nile" wrote in message
...
| Hi,
|
| I have installed office 2007 in Windows XP SP2. Every time i double click
on
| an Excel file to open it, i get the following msg
|
| "test.xls is already open, reopening will cause any changes you made to be
| discarded. Do you want to reopen"
|
| i have searched for this and one suggestion was to register the Excel with
| "excel.exe /regserver"
|
| But this did not fix the problem.
|
| Anyone could help with tihs?
|
| Thanks in advance.
|
|
|




Nile

File already open
 
Hi Jim,

I managed to delete the "%1" by using Microsoft Office Diagnostics. But now
the original problem appeard which is when i double click on Excel file takes
about 1-2 minutes to open however, when i use Open from excel then it is fine.

Any idea?

Many thanks,


"Nile" wrote:

Hi Jim,

Thanks for the reply.

i tried to delete the "%1" but it doese not delete. i clicked ok on the
windows but when i open it agin it is still there. I am an administrator on
this PC but ye cannot delete, not sure how to delete it.

I added the "%1" as it was recommended in one website to overcome a delay
problem. Excel used to take 1-2 mins to open a file so i added the "%1" which
fixed the delay.

Could you help more?

Thanks,

"Jim Rech" wrote:

I'd guess that if you went into My Computer, Tools, Folder Options, File
Types, found XLS, clicked Advanced, selected Open and clicked Edit you would
find a "%1" at the end of the "Application used..." command line. If so,
remove it and OK your way out.

--
Jim
"Nile" wrote in message
...
| Hi,
|
| I have installed office 2007 in Windows XP SP2. Every time i double click
on
| an Excel file to open it, i get the following msg
|
| "test.xls is already open, reopening will cause any changes you made to be
| discarded. Do you want to reopen"
|
| i have searched for this and one suggestion was to register the Excel with
| "excel.exe /regserver"
|
| But this did not fix the problem.
|
| Anyone could help with tihs?
|
| Thanks in advance.
|
|
|




Jim Rech

File already open
 
The file opens twice because you have both %1 and "Use DDE". Since you're
concerned about the slow opening in Excel 2007 you should uncheck Use DDE.
The effect of this however that each time you double-click a file on Windows
Explorer a new Excel instance will be used. With DDE one instance is used.
Pick your poison.<g

--
Jim
"Nile" wrote in message
...
| Hi Jim,
|
| I managed to delete the "%1" by using Microsoft Office Diagnostics. But
now
| the original problem appeard which is when i double click on Excel file
takes
| about 1-2 minutes to open however, when i use Open from excel then it is
fine.
|
| Any idea?
|
| Many thanks,
|
|
| "Nile" wrote:
|
| Hi Jim,
|
| Thanks for the reply.
|
| i tried to delete the "%1" but it doese not delete. i clicked ok on the
| windows but when i open it agin it is still there. I am an administrator
on
| this PC but ye cannot delete, not sure how to delete it.
|
| I added the "%1" as it was recommended in one website to overcome a
delay
| problem. Excel used to take 1-2 mins to open a file so i added the "%1"
which
| fixed the delay.
|
| Could you help more?
|
| Thanks,
|
| "Jim Rech" wrote:
|
| I'd guess that if you went into My Computer, Tools, Folder Options,
File
| Types, found XLS, clicked Advanced, selected Open and clicked Edit you
would
| find a "%1" at the end of the "Application used..." command line. If
so,
| remove it and OK your way out.
|
| --
| Jim
| "Nile" wrote in message
| ...
| | Hi,
| |
| | I have installed office 2007 in Windows XP SP2. Every time i double
click
| on
| | an Excel file to open it, i get the following msg
| |
| | "test.xls is already open, reopening will cause any changes you made
to be
| | discarded. Do you want to reopen"
| |
| | i have searched for this and one suggestion was to register the
Excel with
| | "excel.exe /regserver"
| |
| | But this did not fix the problem.
| |
| | Anyone could help with tihs?
| |
| | Thanks in advance.
| |
| |
| |
|
|
|



Nile

File already open
 
Hi Jim,

it turned out to be a problem with our Sage plugin, when i disabled it
everyting was fine.

Thanks for your help anyway.

"Jim Rech" wrote:

The file opens twice because you have both %1 and "Use DDE". Since you're
concerned about the slow opening in Excel 2007 you should uncheck Use DDE.
The effect of this however that each time you double-click a file on Windows
Explorer a new Excel instance will be used. With DDE one instance is used.
Pick your poison.<g

--
Jim
"Nile" wrote in message
...
| Hi Jim,
|
| I managed to delete the "%1" by using Microsoft Office Diagnostics. But
now
| the original problem appeard which is when i double click on Excel file
takes
| about 1-2 minutes to open however, when i use Open from excel then it is
fine.
|
| Any idea?
|
| Many thanks,
|
|
| "Nile" wrote:
|
| Hi Jim,
|
| Thanks for the reply.
|
| i tried to delete the "%1" but it doese not delete. i clicked ok on the
| windows but when i open it agin it is still there. I am an administrator
on
| this PC but ye cannot delete, not sure how to delete it.
|
| I added the "%1" as it was recommended in one website to overcome a
delay
| problem. Excel used to take 1-2 mins to open a file so i added the "%1"
which
| fixed the delay.
|
| Could you help more?
|
| Thanks,
|
| "Jim Rech" wrote:
|
| I'd guess that if you went into My Computer, Tools, Folder Options,
File
| Types, found XLS, clicked Advanced, selected Open and clicked Edit you
would
| find a "%1" at the end of the "Application used..." command line. If
so,
| remove it and OK your way out.
|
| --
| Jim
| "Nile" wrote in message
| ...
| | Hi,
| |
| | I have installed office 2007 in Windows XP SP2. Every time i double
click
| on
| | an Excel file to open it, i get the following msg
| |
| | "test.xls is already open, reopening will cause any changes you made
to be
| | discarded. Do you want to reopen"
| |
| | i have searched for this and one suggestion was to register the
Excel with
| | "excel.exe /regserver"
| |
| | But this did not fix the problem.
| |
| | Anyone could help with tihs?
| |
| | Thanks in advance.
| |
| |
| |
|
|
|




Alan[_10_]

File already open
 
On Apr 23, 11:12*pm, Nile wrote:
Hi Jim,

it turned out to be a problem with our Sage plugin, when i disabled it
everyting was fine.

Thanks for your help anyway.



"Jim Rech" wrote:
The file opens twice because you have both %1 and "Use DDE". *Since you're
concerned about the slow opening inExcel2007 you should uncheck Use DDE.
The effect of this however that each time you double-click a file on Windows
Explorer a newExcelinstance will be used. *With DDE one instance is used.
Pick your poison.<g


--
Jim
"Nile" wrote in message
...
| Hi Jim,
|
| I managed to delete the "%1" by using Microsoft Office Diagnostics. But
now
| the original problem appeard which is when i double click onExcelfile
takes
| about 1-2 minutes toopenhowever, when i useOpenfromexcelthen it is
fine.
|
| Any idea?
|
| Many thanks,
|
|
| "Nile" wrote:
|
| Hi Jim,
|
| Thanks for the reply.
|
| i tried to delete the "%1" but it doese not delete. i clicked ok on the
| windows but when iopenit agin it is still there. I am an administrator
on
| this PC but yecannotdelete, not sure how to delete it.
|
| I added the "%1" as it was recommended in one website to overcome a
delay
| problem.Excelused to take 1-2 mins toopena file so i added the "%1"
which
| fixed the delay.
|
| Could you help more?
|
| Thanks,
|
| "Jim Rech" wrote:
|
| I'd guess that if you went into My Computer, Tools, Folder Options,
File
| Types, found XLS, clicked Advanced, selectedOpenand clicked Edit you
would
| find a "%1" at the end of the "Application used..." command line. *If
so,
| remove it and OK your way out.
|
| --
| Jim
| "Nile" wrote in message
| ...
| | Hi,
| |
| | I have installed office 2007 in Windows XP SP2. Every time i double
click
| on
| | anExcelfile toopenit, i get the following msg
| |
| | "test.xls is alreadyopen, reopening will cause any changes you made
to be
| | discarded. Do you want to reopen"
| |
| | i have searched for this and one suggestion was to register the
Excelwith
| | "excel.exe /regserver"
| |
| | But this did not fix the problem.
| |
| | Anyone could help with tihs?
| |
| | Thanks in advance.
| |
| |
| |
|
|
| - Hide quoted text -


- Show quoted text -


Hi,

I had similar problems, but my excel files are corrupted. I got my
problem solved by using a utility called Advanced Excel Repair to
repair my Excel xls file. It works rather well. Its web address is
http://www.datanumen.com/aer/ Hope this will help.

Alan


All times are GMT +1. The time now is 03:02 PM.

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