XL 2K Paste special problems

C

CB

I have a client with Excel 2000 (Win NT). Her PC just got
rebuilt and now when she does a paste special in Excel
instead of seeing a choice of all, formulas, etc... she
sees options like you'd see in Word (i.e. object,
etc...). Does anyone know of an option that might fix
that? In the meantime I've asked for a reinstall, but if
I could save them the work, they'd appreciate it.

Thanks,
CB
 
B

Bob Umlas

Sounds like she didn't COPY cells, but perhaps copied a bitmap image or a
web part,and Excel couldn't paste non-excel source. Try this to see if Excel
is working "OK":
select A1, Edit/Copy, Select B1, Edit Paste Special and see if you have the
"right" dialog.
Bob Umlas
Excel MVP
 
D

Dave Peterson

Another way to get that "paste special" dialog is to copy from one instance of
excel to another.

If she opened the second instance on purpose (I hate this), then ignore this.

If she wants to open all workbooks in the same instance of excel, then
sometimes, one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
Top