Paste Special Help (Excel 2003)


N

Newbeetle

Hi, Strange thing has started with Paste Special from one workbook to another
although in the same workbook the function is fine;

When I copy from one workbook, go to the other and select Paste Special the
new window pop up is strange and shows a list to select from as follows;

MS Office Excel Object
Picture (Enhanced Metafile)
Bitmap
MS Excel 8 format
Biff5
Biff4
Biff3
Biff
SYLK
WK1
DIF
XML Spreadsheet
HTML
Unicode Text
Text
CSV
Hyperlink


Any ideas much welcomed.

Regards Newbeetle
 
Ad

Advertisements

D

Dave Peterson

Make sure you have both workbook files open in the same instance of excel.

Close one workbook (and that instance of excel) and use File|open to open the
second file.

Then try it.
 
N

Newbeetle

Thanks Dave,

Works a treat, funny I don't recall opening the sheets that way before , so
I guess memory loss is settling in as I do this monthly oh well.
 
G

Gord Dibben

You may have checkmarked Tools>Options>Generl "Ignore other application" which
would cause you to open a distinct instance of Excel for each file opened by
double-click.

Tools>Options>General Uncheck "Ignore Other Applications"

If no joy with that................

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(quotes required)>OK.


Gord Dibben MS Excel MVP
 
Ad

Advertisements

N

Newbeetle

Cheers Gord,

It always great this site for fast response, glad you guys are out there! I
tried your idea but have the same problem, but no probs at least I have a
solution and can sleep tonight.


Thanks to everyone for your help as always.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top