Excel Files Acting Weird

B

Befuddled

I just got upgraded to WinXP and Excel 2000 (SP-3). Now when I try to copy
cells from a worksheet in one workbook to a worksheet in a second workbook,
Excel is treating the copied cells as MS Excel Worksheet Objects, and
formulas are not being copied. Also Excel files opened from email attachments
are re-opening Excel so I can't tile two files. All of these problems only
cropped up this week when I got the upgrades.

Larry
 
T

tamarakay

For the second part of your question, Tools, Options, on the View tab uncheck
Windows in Taskbar.
 
G

Gord Dibben

Larry

Try to re-register Excel.

Close Excel first and
On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK.

Gord Dibben Excel MVP
 
B

Befuddled

Gord, I'm at work and the LAN guys here take a dim view of me tinkering with
my PC. They, however, are somewhat at a loss to explain the Excel problem.
 
B

Befuddled

Figured out why I was having trouble with emailed Excel files. Went into My
Computer/Tools/Folder Options/File Types. XLS was referred to as an XLS File
instead of a Microsoft Excel Worksheet. DDE codes were missing. When I opened
and examined XLB aka Microsoft Excel Worksheet, the DDE codes for "New",
"Print" and "Printto" magically transmorgified to XLS and Voila! I'm back in
business.

Thanks
 
D

Dave Peterson

One of the things that the /unregserver and /regserver stuff (that Gord
suggested) does is to fix the registry entries for excel--including what you did
manually.

(I find running those two commands much safer than playing in the File Types
dialog.)
 
B

Befuddled

Dave, the LAN guys tried those commands and nothing happened. They had pretty
much given up and moved on when I thought of looking in File Types again.
 
A

Anat

I am having the same problems Excel files not being able to open from e-mail
attachments. I tried the unregserver and regserver as mentioned in the
previous posting but no luck. Any ideas?

Thanks
 
Top