No 'paste special'

I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
1024M. I am trying to transpose some rows and columns and Paste Special is
grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
or ?.? Is there a work around without reinstalling any or all of the above?

Is the sheet protected?

or even more likely, is there anything in the clipboard that can be pasted
with pastespecial?

--
Regards,
Tom Ogilvy


"Milco" wrote:

> I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> 1024M. I am trying to transpose some rows and columns and Paste Special is
> grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> or ?.? Is there a work around without reinstalling any or all of the above?

Page is NOT protected and clipboard is empty.

"Milco" wrote:

> I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> 1024M. I am trying to transpose some rows and columns and Paste Special is
> grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> or ?.? Is there a work around without reinstalling any or all of the above?

Hi, so when your clipboard is empty Paste special will be grayed (disabled)
for ever and also Paste. Put some data in your clipboard and then should
everything be enabled.

Henrich

„Milco" napÃ*sal (napÃ*sala):

> Page is NOT protected and clipboard is empty.
>
> "Milco" wrote:
>
> > I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> > 1024M. I am trying to transpose some rows and columns and Paste Special is
> > grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> > or ?.? Is there a work around without reinstalling any or all of the above?

Sorry but I meant that Clipboard was empty beofre I Cut and then tried to
Paste Special.

"Henrich" wrote:

> Hi, so when your clipboard is empty Paste special will be grayed (disabled)
> for ever and also Paste. Put some data in your clipboard and then should
> everything be enabled.
>
> Henrich
>
> „Milco" napÃ*sal (napÃ*sala):
>
> > Page is NOT protected and clipboard is empty.
> >
> > "Milco" wrote:
> >
> > > I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> > > 1024M. I am trying to transpose some rows and columns and Paste Special is
> > > grayed out and unavailable. Is this a problem with Office, Excel, XP(home),
> > > or ?.? Is there a work around without reinstalling any or all of the above?

Milco -

If you first choose Edit | Cut, Paste Special is greyed out.

If you first choose Edit | Copy, Paste Special is available.

- Mike
www.mikemiddleton.com

"Milco" <Milco@discussions.microsoft.com> wrote in message
news:EE8D1B55-5E45-41FD-B0CA-B8D22CB42E2E@microsoft.com...
>I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> 1024M. I am trying to transpose some rows and columns and Paste Special
> is
> grayed out and unavailable. Is this a problem with Office, Excel,
> XP(home),
> or ?.? Is there a work around without reinstalling any or all of the
> above?

Thanks, that did the trick. Actually I selected range, then CTRL X as per
the answer to my question under Excel-Worksheet function asking how to
convert rows to columns.

"Mike Middleton" wrote:

> Milco -
>
> If you first choose Edit | Cut, Paste Special is greyed out.
>
> If you first choose Edit | Copy, Paste Special is available.
>
> - Mike
> www.mikemiddleton.com
>
> "Milco" <Milco@discussions.microsoft.com> wrote in message
> news:EE8D1B55-5E45-41FD-B0CA-B8D22CB42E2E@microsoft.com...
> >I am using Excel 2002 (10.6501.6714)SP1 and recently upgrded my memory to
> > 1024M. I am trying to transpose some rows and columns and Paste Special
> > is
> > grayed out and unavailable. Is this a problem with Office, Excel,
> > XP(home),
> > or ?.? Is there a work around without reinstalling any or all of the
> > above?
>
>
>

Check for the Skype Click to Call browser plugin. If you have it disable/uninstall it. It is known to disrupt clipboard functionality. Check the Skype forums - they have a fix for that plugin now.

EDIT: BTW - you should start your own thread (as per the forum rules) - this thread is more than 6 years old