Paste Special function to transpose data

[Kev_Astan]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

In Excel 2004 and previous versions, I made use of the 'Paste Special' function. So I have experience and ought to know what to do. I have tried it in Excel 2008, to which I upgraded recently, what a disappointment. I get either no option to use it (the function is greyed out) or if I do I do not get the dialog that includes 'Transpose values' option. Any idea what has happened in this upgrade and any answers?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

In Excel 2004 and previous versions, I made use of the 'Paste Special'
function. So I have experience and ought to know what to do. I have tried it
in Excel 2008, to which I upgraded recently, what a disappointment. I get
either no option to use it (the function is greyed out) or if I do I do not
get the dialog that includes 'Transpose values' option. Any idea what has
happened in this upgrade and any answers?

I have no idea. Paste-Special transpose works fine in Office 2008 just as it
has done in all prior versions. Are you aware that you can only transpose
after a copy, not a cut? Please report your exact steps including the cells
involved and we'll try to help further.

 

[bramm]

I have exactly the same problem as the first guy who started this post.

The whole "paste special dialog" looks different. It comes up with this
crapy dialog thing that says paste and paste link stuff. Nothing like the
thing I'm used up..

 

[JE McGimpsey]

I have exactly the same problem as the first guy who started this post.

The whole "paste special dialog" looks different. It comes up with this
crapy dialog thing that says paste and paste link stuff. Nothing like the
thing I'm used up..

Are you copying directly from the worksheet? If you're getting the Paste
Link dialog, XL doesn't recognize what's on the clipboard as copied
cells.

Do you have any objects (pictures, shapes, etc) in the copy range?

 

[CyberTaz]

Additional to what John & Bob G replied: If you've recently installed 2008
make sure you apply all updates beginning with 12.5.0 through 12.1.3 and
that OS X is fully up to date using the 10.4.11 Combo updater from the Apple
Downloads site:

http://www.apple.com/support/downloads/

Repairing Disk Permissions can't hurt afterward, nor would a shut
down/restart of the Mac. As the others have indicated, I've been running
2008 on a G5 in Tiger without any such problem, so it isn't endemic to the
program.

HTH |:>)
Bob Jones
[MVP] Office:Mac