(Msg. 1) Posted: Fri Jul 25, 2008 6:48 am
Post subject: Missing options under Paste Special Archived from groups: microsoft>public>excel>crashesgpfs (more info?)
I have a client in my office who is trying to copy a worksheet from one
spreadsheet to another. He highlights all the cells, right clicks and
copies. He then opens a new speadsheet and click A1. Then he right click and
chooses Paste Special. A option menu appears but it is not a normal option
menu. There is no Check boxes.. The dialog box looks like a standard pull
down menu with options I ahve never seen before. I can open a blank sheet
and add formulas. I do the same procedure and with the same results. It
doesn't happen all the time but it is very frequent. I run a reinstall of
office and the condition has not changed. Has anyone had a similar issue and
did you solve the problem?
--
Michael Stape
(Msg. 2) Posted: Fri Jul 25, 2008 8:21 am
Post subject: RE: Missing options under Paste Special [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Options like:
Microsoft Office Excel Worksheet Objet
Picture
Bitmap
MS Excel 8.0
etc.
??
When you copy from one instance of excel to another, this occurs. You can
either open your destination in the same instance of excel or you can choose
the 'correct' option from the list you see. What are you trying to paste?
--
-SA
"MW Stape" wrote:
> I have a client in my office who is trying to copy a worksheet from one
> spreadsheet to another. He highlights all the cells, right clicks and
> copies. He then opens a new speadsheet and click A1. Then he right click and
> chooses Paste Special. A option menu appears but it is not a normal option
> menu. There is no Check boxes.. The dialog box looks like a standard pull
> down menu with options I ahve never seen before. I can open a blank sheet
> and add formulas. I do the same procedure and with the same results. It
> doesn't happen all the time but it is very frequent. I run a reinstall of
> office and the condition has not changed. Has anyone had a similar issue and
> did you solve the problem?
> --
> Michael Stape
>
(Msg. 3) Posted: Sat Jul 26, 2008 6:26 am
Post subject: RE: Missing options under Paste Special [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
They are working in 2 seperate instances of Excel and that is the exact menu.
The person is copying engineering numbers for manufacturing barges.
So if I just open from the same copy it will be fine?
--
Michael Stape
"StumpedAgain" wrote:
> Options like:
> Microsoft Office Excel Worksheet Objet
> Picture
> Bitmap
> MS Excel 8.0
> etc.
> ??
>
> When you copy from one instance of excel to another, this occurs. You can
> either open your destination in the same instance of excel or you can choose
> the 'correct' option from the list you see. What are you trying to paste?
> --
> -SA
>
>
> "MW Stape" wrote:
>
> > I have a client in my office who is trying to copy a worksheet from one
> > spreadsheet to another. He highlights all the cells, right clicks and
> > copies. He then opens a new speadsheet and click A1. Then he right click and
> > chooses Paste Special. A option menu appears but it is not a normal option
> > menu. There is no Check boxes.. The dialog box looks like a standard pull
> > down menu with options I ahve never seen before. I can open a blank sheet
> > and add formulas. I do the same procedure and with the same results. It
> > doesn't happen all the time but it is very frequent. I run a reinstall of
> > office and the condition has not changed. Has anyone had a similar issue and
> > did you solve the problem?
> > --
> > Michael Stape
> >
(Msg. 4) Posted: Mon Jul 28, 2008 3:01 am
Post subject: Re: Missing options under Paste Special [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
(Msg. 5) Posted: Mon Jul 28, 2008 10:18 am
Post subject: RE: Missing options under Paste Special [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If you copy within the same instance, the "regular" past special menu that
you're used to should show up. Depending on what you're trying to copy/paste
you can select a number of options from this list or you may want to open the
two spreadsheets in the same instance of Excel (instead of opening another
instance, just click File->Open->YourFile). I hope this helps!
--
-SA
"MW Stape" wrote:
> They are working in 2 seperate instances of Excel and that is the exact menu.
> The person is copying engineering numbers for manufacturing barges.
>
> So if I just open from the same copy it will be fine?
> --
> Michael Stape
>
>
>
> "StumpedAgain" wrote:
>
> > Options like:
> > Microsoft Office Excel Worksheet Objet
> > Picture
> > Bitmap
> > MS Excel 8.0
> > etc.
> > ??
> >
> > When you copy from one instance of excel to another, this occurs. You can
> > either open your destination in the same instance of excel or you can choose
> > the 'correct' option from the list you see. What are you trying to paste?
> > --
> > -SA
> >
> >
> > "MW Stape" wrote:
> >
> > > I have a client in my office who is trying to copy a worksheet from one
> > > spreadsheet to another. He highlights all the cells, right clicks and
> > > copies. He then opens a new speadsheet and click A1. Then he right click and
> > > chooses Paste Special. A option menu appears but it is not a normal option
> > > menu. There is no Check boxes.. The dialog box looks like a standard pull
> > > down menu with options I ahve never seen before. I can open a blank sheet
> > > and add formulas. I do the same procedure and with the same results. It
> > > doesn't happen all the time but it is very frequent. I run a reinstall of
> > > office and the condition has not changed. Has anyone had a similar issue and
> > > did you solve the problem?
> > > --
> > > Michael Stape
> > >
(Msg. 6) Posted: Thu Oct 29, 2009 7:18 am
Post subject: re: Missing options under Paste Special [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
While the "2nd instance of Excel" explanation helped me, and technically applies, i've been able to paste special between two instances of Excel in the past.
The reason I did not see the expected "paste special" options was because i was copying from a spreadsheet that was opened from an EMBEDDED OBJECT in MS Word 2003.
When I saved the embedded spreadsheet to the hard drive and re-opened from Excel, the expected "paste special" options were available.
Hope that helps someone else.
StumpedAgai wrote:
RE: Missing options under Paste Special
25-Jul-08
Options like:
Microsoft Office Excel Worksheet Objet
Picture
Bitmap
MS Excel 8.0
etc.
??
When you copy from one instance of excel to another, this occurs. You can
either open your destination in the same instance of excel or you can choose
the 'correct' option from the list you see. What are you trying to paste?
--
-SA
"MW Stape" wrote:
Previous Posts In This Thread:
On Friday, July 25, 2008 9:48 AM
MWStap wrote:
Missing options under Paste Special
I have a client in my office who is trying to copy a worksheet from one
spreadsheet to another. He highlights all the cells, right clicks and
copies. He then opens a new speadsheet and click A1. Then he right click and
chooses Paste Special. A option menu appears but it is not a normal option
menu. There is no Check boxes.. The dialog box looks like a standard pull
down menu with options I ahve never seen before. I can open a blank sheet
and add formulas. I do the same procedure and with the same results. It
doesn't happen all the time but it is very frequent. I run a reinstall of
office and the condition has not changed. Has anyone had a similar issue and
did you solve the problem?
--
Michael Stape
On Friday, July 25, 2008 11:21 AM
StumpedAgai wrote:
RE: Missing options under Paste Special
Options like:
Microsoft Office Excel Worksheet Objet
Picture
Bitmap
MS Excel 8.0
etc.
??
When you copy from one instance of excel to another, this occurs. You can
either open your destination in the same instance of excel or you can choose
the 'correct' option from the list you see. What are you trying to paste?
--
-SA
"MW Stape" wrote:
On Saturday, July 26, 2008 9:26 AM
MWStap wrote:
They are working in 2 seperate instances of Excel and that is the exact menu.
They are working in 2 seperate instances of Excel and that is the exact menu.
The person is copying engineering numbers for manufacturing barges.
So if I just open from the same copy it will be fine?
--
Michael Stape
"StumpedAgain" wrote:
On Monday, July 28, 2008 12:13 AM
karuna_12 wrote:
no need to select all in new spredsheet
no need to select all in new spredsheet
On Monday, July 28, 2008 1:18 PM
StumpedAgai wrote:
If you copy within the same instance, the "regular" past special menu that
If you copy within the same instance, the "regular" past special menu that
you're used to should show up. Depending on what you're trying to copy/paste
you can select a number of options from this list or you may want to open the
two spreadsheets in the same instance of Excel (instead of opening another
instance, just click File->Open->YourFile). I hope this helps!
--
-SA
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office