Excel oddity

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
80
Location
New York
Open two separate sessions of Excel.
Put any data in A1:B10
Hide rows 2:9
Select A1:B10, use goto special/Visible cells only.
Copy
In a 2nd sheet of same workbook, paste. You get what you expect.
In a sheet from the 2nd session of Excel, Paste. You DON'T get what you expect.:eyebrows:

Any good explanation of why the difference?
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
This works correctly if you open excel and create a new workbook from within.

When you open excel twice from the start menu it opens in a separate instance and you lose some functionality when you try to go between the two and you can't access macros from workbooks in the other instance.

Not really sure why this is or what the limitations are, I would be interested in understanding it as well.

Jesse
 

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
80
Location
New York
Actually, you CAN access macros in the other instance - mainly need to set a reference to it. However, what you did was reiterate the oddity -- I did say it works fine in the same instance, but odd in a 2nd instance.
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Yes, I did reiterate only I said second workbook in the same instance vs second worksheet.

Forum is new, I was looking for excuses to post. Didn't intend to offend.
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
Let me preface with, "Bob, I have no idea." :)

Perhaps it's a different clipboard of the two, and special cells do not get passed the same. Have you tried other types of special cells? I haven't, but will in a little bit.
 

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
80
Location
New York
Figured it was a different clipboard but still falls under the category of "oddity", IMHO
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Absolutely. I wouldn't expect you to find anything less. :)

LOL!

Interesting though... if you're using Excel 2010, right click the sheet in the second workbook and choose Paste Special -> Match Destination Formatting. It gives you what you'd expect. So obviously, clipboard differences or not, the original selection is still held somewhere.

I would agree that the default should match with the original Excel instance though.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,522
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Agreed, Jon. I'm most surprised in this case that the PasteSpecial actually gets it right though. I actually did expect that pasting to the second workbook wouldn't work as you'd expect. (That's not a contradiction is it?)
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
In testing on my machine, Win XP, Excel 2010 (no other versions on this machine), I can't access the Paste Special dialog box at all. In fact, I can't access anything except the standard Paste functionality. When I just paste it does so, but doesn't leave out hidden cells and it leaves the formulas as values. Surprisingly enough, if using AutoFilter it only pastes the visible cells. It even told me I couldn't paste formulas from another instance of Excel. Same error for both hidden cells and AutoFiltered cells. I'd never seen that one before. My assumption is one Office clipboard initialized in the first instance??
 
Top