Hi Richard;
Do you mean that when you choose Paste Special>Formulas, Excel pastes the cell
values as well as the formula? This has been the case with every version of
Excel I have ever tried to use, and with every Mac OS going back to System 8
(yes, that long ago!)
Balderdash !
Excel does not & never has worked in this manner... And I go
back to DOS-based spreadsheets predating the origin of the Mac & have been
using Macs ever since. The method you describe pastes the Formula only &
excludes any formatting copied from the origin. Whether the formula result
(Value) is different depends on whether it includes Absolute References.
This may be a Mac specific glitch, in which case Bill
Gates' Little Helpers won't be much help. Ask your Vista addicted mates if it
happens on PC's also.
Yes, it works this way on the PC is well and there is no "glitch". When you
paste the formula that's exactly what you get. It isn't the feature that's
'glitchy' if the formula you're copying isn't written in the manner it
should be based on what you actually need to have pasted.
I gave up on Excel because it won;t do a lot of things -
including Paste Formulas properly - that the DTP suite I have been using for
20 years will do. I can't tell you the name of this German manufactured DTP
because this is an Excel forum . . .
Here, Richard, let me set the example for you: ADOBE, FILEMAKER, LOTUS,
QUARK, APPLE... Name anything you'd like. There is no secret police force
that will drag you from your bed at 3 a.m. for mentioning something other
than the Microsoft name in these forums.
This is the second of your posts I've seen where you've erroneously
criticized Mac Office software & MS in general. You're most certainly
entitled to your opinions, but spouting misconceptions as fact is not what
this -- or any other -- support group is about. If you have nothing
productive to offer there's no reason to reply at all.
Also, as pointed out before, there is no ban here on suggesting alternative
products in any given scenario. Yet you continue to allude to some
mysterious "German manufactured DTP" which you are reticent to name. Not
knowing what "suite" it is I certainly can't deny or endorse its
capabilities, but "DTP" is generally used as an acronym for Desk Top
Publishing. I've been involved in that field since prior to the advent of
PageMaker & have yet to see a DTP *suite*. Several DTP *programs* have
included Table features which offer calculation capabilities, but nothing
that rivals what dedicated spreadsheet apps can do.
Please understand that I'm by no means asserting that Excel is the "end all
& be all" of spreadsheet programs -- it certainly has its rivals and each
have their relative strong points & weaknesses. I'll admit that I'm a bit
curious about what this magic Desk Top Publishing elixir is that transcends
what is generally acknowledged as one of the most powerful & full-featured
*spreadsheet* programs on the planet.
Regards |:>)
Bob Jones
[MVP] Office:Mac
