File already open

N

Nile

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.
 
J

Jim Rech

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
| 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.
|
|
|
 
N

Nile

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,
 
N

Nile

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,
 
J

Jim Rech

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
| 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
| > > | > > | 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.
| > > |
| > > |
| > > |
| > >
| > >
| > >
 
N

Nile

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.
 
A

Alan

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.






- 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top