ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can Only open files using file ~ open (https://www.excelbanter.com/excel-discussion-misc-queries/34729-can-only-open-files-using-file-%7E-open.html)

tek4u

Can Only open files using file ~ open
 
Workstation running W2K sp4, O2K, Excel ver 9.0 build 2719.
I must open excel first and then use file open on this particular
workstation, the same files open fine on other workstations fine.
Location does not seem to matter, network files vs local. Renaming
files did nothing as well, Uninstalled the Office Suite and
Reinstalled - Same Pblm. If I open my documents and attempt to open an
excel file I get the following. A window opens showing Excel with the
tool bar being visable but were my sheet data should be is being
replaced with a screen shot of the current desktop. Thx in advance ~
tek


Ron de Bruin

Hi

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register 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.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tek4u" wrote in message oups.com...
Workstation running W2K sp4, O2K, Excel ver 9.0 build 2719.
I must open excel first and then use file open on this particular
workstation, the same files open fine on other workstations fine.
Location does not seem to matter, network files vs local. Renaming
files did nothing as well, Uninstalled the Office Suite and
Reinstalled - Same Pblm. If I open my documents and attempt to open an
excel file I get the following. A window opens showing Excel with the
tool bar being visable but were my sheet data should be is being
replaced with a screen shot of the current desktop. Thx in advance ~
tek




tek4u

Ron, Thx for the suggestions, I have tried the first and I only did
the regserver. I will
go back and try the unregister first and reregister to see if that
makes a difference.
thx. tek


tek4u

Ron,

Redoing the regserver portion did fix the pblm, the unreserver portion
must be done is some cases. Thx again ~ tek


Ron de Bruin

You are welcome

Thanks for the feedback

--
Regards Ron de Bruin
http://www.rondebruin.nl


"tek4u" wrote in message oups.com...
Ron,

Redoing the regserver portion did fix the pblm, the unreserver portion
must be done is some cases. Thx again ~ tek





All times are GMT +1. The time now is 11:41 PM.

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