Hidden and Invisible Objects

re: Hidden and Invisible Objects

Jan Karel Pieterse — Sat, 31 Jan 2009 21:33:55 GMT

I have seen similar problems myself.

What I also noted, was that the performance hit is far, far worse for Excel 2007, compared to older versions.

re: Hidden and Invisible Objects

hb — Mon, 02 Feb 2009 19:34:07 GMT

good article, but an easier way is to avoid pasting the objects in the first place by using paste special/values which will just give you the text from web site or wherever

re: Hidden and Invisible Objects

Jason — Mon, 02 Feb 2009 20:29:12 GMT

hb - sometimes that boogers things up because it may paste everything into column A.

What I've found is easiest is this:

1. paste your data into a sheet

2. copy the whole sheet

3. in another sheet, select whole sheet, paste special / values

4. delete original sheet

re: Hidden and Invisible Objects

Harlan Grove — Tue, 03 Feb 2009 04:26:28 GMT

Since copying from an Excel range in an open workbook in an Excel session includes sufficient metainformation to allow Paste Link into any range in any worksheet in any open workbook in the same Excel session, it should be possible to tell when the user is pasting from a source other than the same Excel session. How difficult would it be to add an option to make Excel *ALWAYS* display the [external source] Paste Special dialog when the user tries to paste using right-click/Paste, Edit/Paste, [Ctrl]+V or [Shift]+[Insert]? Even better, make that dialog default to plain text?

Is it truly equivalent to rocket science to come up with potentially useful user options like this?

re: Hidden and Invisible Objects

Joy Lynford — Thu, 05 Feb 2009 09:40:21 GMT

my work demands me the lesson of this kind. and i was very upset that i was not able to cope up with the lesson thought by my seniors. if not because of you i would have been in a soup. thanks