View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Roger Roger is offline
external usenet poster
 
Posts: 226
Default Double click on icon opens Excel but does not open file

Tried Ignore check nope
Tried the unregister nope
Tried the full path regserver nope.

My problems began after installing Office 2007 with a problem with Excel
2007 not functioning correctly with the workbook that did work under
Excel-2003 and Excel-97. It took 1:45 to just open the file and 2:05 th
change the value in a single cell.

After spending about 40 hours completely writing a new version of the
workbook with it's 800+ cells with data, formula and cross worksheet
references, but NO MACROS, I thought I was ready to actually start to use
Excel-2007.

However the workbook has developed another problem.

It would not open with a double click in Explorer. It will only open when I
click OPEN in EXCEL

To test I did the following:
I saved a number of copies of the file on my desktop as XLS type, XLSM type,
and XLSX type I also have a copy of the old workbook that would open after
1:45

With no other applications running Double clicking on the XLS or XLSX
files opened them in just a few seconds
double clicking on the old Excel-2003 file opened it in the normal 1:45
double clicking on the XLSM file did not open it.

Note I have not yet included the macros that I had in the old Excel-2003
workbook but was planning on writing them this weekend.

So it looks like there still are serious problems with Excel-2007. I think
I will look into Open Office and see if it can run a spreadsheet.



"Gord Dibben" wrote:

Amy

Re-read Dave's post.

He did not say to run regserver.xls

Here is my version of the instructions..................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK.


Gord Dibben MS Excel MVP

On Mon, 7 Jul 2008 16:16:30 -0700, Amy Heine <Amy
wrote:

IGNORE OTHER APPLICATIONS is not checked. Running excel / unregserver or
excel / regserver both tried to open excel with the response of regserver.xls
could not be found.