Well, no luck. This morning when i came in I can no longer access MS Online
Help, even when adjusting the Tools/Options/Services & changing the Online
Services. by the way...this is true for all MS Office 2003 applications.
Also, i can't double click an excel file and open it in excel. as before,
excel opens, but not the file. this time, i got two error messages...the
first was the the file i was trying to open couldn't be found. The second
was that 'C:\Documents.xls' cojuld not be found. Then 'C:\and.xls' could not
be found. then 'Settings\cartj...' and so on. I got these messages until
they got to the end of my file's name. Really weird. So, re-registering
didn't work, and now making the change the Open setting under file types
doesn't work. I can make it work by eliminating the DDE field and adding </e
%1 to the end of the application path. But these changes will not stay once
i close excel.
I did just try it the way you originally suggested...the end of the
application string is now just /e, and i checked Use DDE and added
[open("%1")]. This time, i got the same "can't find file" as i mentioned
above (several until i reached the end of the file name), but this time the
file opened after all of that.
Finally, even if the "ignore other applications" box remains unchecked, it
no longer works to allow me to double click a file to open it in excel...i
get the same "can't find file" messages as above; excel opens, but not the
file.
this is wild. thanks again for your help.
jeffc4442
"Gord Dibben" wrote:
Thanks and hope it works out.
Gord
On Fri, 12 Jan 2007 15:10:01 -0800, jeffc4442
wrote:
Gord:
i fixed it. i added </e "%1" to the end of the command line and deleted
what was in the DDE box. it worked. we'll see if it lasts. this is my
office computer, so i'll find out more on monday...i'm out!
have a good weekend, Gord.
jeff
"Gord Dibben" wrote:
Try re-registering Excel..............
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"(no quotes)OK.
One more thing to try if none of the above brings joy.........
Go to StartSettingsFolderOptionsFile Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit select "Open" and Edit.
If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.
In Command line the path should be similar to this....
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e (delete the <sp/e if
you want Book1 to open.
You must have the double quotes.
Below have "use DDE" checked and this in the DDE message box....[open("%1")]
Application should read "Excel"(no quotes)
Gord
On Fri, 12 Jan 2007 13:11:01 -0800, jeffc4442
wrote:
Thanks, Gord. I do have full control.
i did what you said and selecting and deselecting 'ignore other
applications' did change the registry key as you said. however, now even
checking or unchecking 'ignore other apps' fixes the problem. I have run
Detect & Repair several times.
Using this toggle worked before and earlier today, but as i said, it didn't
stick. There are a couple of other things that haven't stuck either...one of
them was a change to how excel opens by modifying the command for .xls in the
tools/folders/file types/.xls/advance/open area. by the way...i didn't
change this command until long after these problems started.
thanks again for taking the time to help. i look forward to hearing what
you think.
jeffc4442
"Gord Dibben" wrote:
The "ignore other applications" setting is stored in the Registry.
If changing it does not stick between sessions, perhaps you do not have
permission to alter the Registry?
Have your account permissions been changed in the past week?
WARNING.....the following concerns opening the Registry Editor.
StartRun "regedit"(no quotes)OK
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
In right-hand side will be a key Options REG_DWORD with a value of
0x00000117(279) if "ignore other applications" is checked.
0x00000157(343) if unchecked.
Close the Registry Editor, open Excel, change the "ignore other applications"
and close Excel.
Re-open the Registry Editor.........has your change in Excel been picked up in
the Options REG_DWORD value?
While in the Registry select Options on right-side and EditPermissions.
Do you have "full control" as a user?
Gord Dibben MS Excel MVP
On Fri, 12 Jan 2007 07:19:02 -0800, jeffc4442
wrote:
Richard:
This worked for me yesterday, but the Ignore Other Applicatins option was
checked when i restarted my computer this morning. Any idea why that would
happen? Is there a way to stop it from doing this? This entire problem just
started on its own earlier this week.
thanks!
jeffc4442
"RichardSchollar" wrote:
In Excel go ToolsOptionsGeneral tab and make sure that "Ignore other
applications" is unchecked.
Best regards
Richard
--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=545761