Silly little annoyance

[Guest]

Greetings all,

Silly little thing that bugs me. I'd like to turn off the prompt I receive
whenever I exit Excel (2003). If I have previously used the Windows
Clipboard to copy ANYTHING, be it the contents of one cell or a whole
spreadsheet, Excel just has to ask me whether or not I want to keep a
"large" amount of data in the Clipboard for use with other applications. YES
YES YES, just stop asking me every time I exit Excel!

Thanks for your help. Happy Holidays!

Larry

 

[Dave Peterson]

If you hit the Escape key before you close excel, do you get the warning.

 

[Guest]

Dave, yes that stops the annoying warning dialog, but I DO want the
contents to remain in the Clipboard, I just want Excel to stop worrying and
completely ignore what is or isn't in the Clipboard when I exit.

Thanks,

 

[Dave Peterson]

I don't think you can turn this behavior off.

You might be able to use a macro to dismiss the warning, but just running a
macro causes the clipboard to be cleared.

And then instead of being irritated by having to click to dismiss the dialog,
you'd be irritated by having to run the code.

And this ain't much of a tip, but you can hit the Y key if your fingers are on
the keyboard.

 

[Guest]

Thanks Dave.

I just don't understand why Excel thinks one cell or one row is "a large
amount of information." Must be some sort of holdover from the days of Excel
4.0, Windows 3.1 and 386 processors.

Larry

 

[Gord Dibben]

Larry

Or maybe a holdover from Version 2(1987) which was designed to run on Windows
2.0(1987) and 80286 processors.

Gord Dibben Excel MVP

Thanks Dave.

I just don't understand why Excel thinks one cell or one row is "a large
amount of information." Must be some sort of holdover from the days of Excel
4.0, Windows 3.1 and 386 processors.

Larry

 

[Dave Peterson]

Just to add to Gord's reply...

It may depend on how you categorize "a large amount". Remember that excel will
keep track of the formula, values, and formatting for that copied range. And
that could be lots of information.

Thanks Dave.

I just don't understand why Excel thinks one cell or one row is "a large
amount of information." Must be some sort of holdover from the days of Excel
4.0, Windows 3.1 and 386 processors.

Larry