
Signature
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
The question becomes which is more important: posting the question/answer
here and all of us learning from it, and I readily admit this is an added
benefit to the entire process.
However, is not the 'prime directive' to assist others? If the inability to
express a problem combined with a rather terse "we don't like attachments
here" results in someone leaving without assistance, hasn't everyone lost?
It amazes me, and I've brought this up to MSFT through my MVP Lead, that the
ability to upload pretty much doesn't exist here. You'd think with all the
computing power and storage available that such a feature doesn't exist.
Besides the example I gave earlier, just finished (not) helping someone that
had a problem, only to find that auto-calculate had been turned off in his
problematic workbook. No way to 'see' that at a distance, but an examination
of the workbook would have revealed it right away. Luckily he was not
someone to just sit and wait on a solution to fall in his lap, kept looking
and found the problem himself.
I just think we all lose something because the ability doesn't exist,
whereas, with the ability we would all have another tool to use to provide
even better assistance, and provide it faster, on occassion.
> Pat-on-the-back for your offer, to the OP, but this means that the rest of
> us will miss out :-(
[quoted text clipped - 30 lines]
> >> am
> >> able to post the actual spreadsheets to go with the questions?
Dave Peterson - 05 Sep 2006 02:23 GMT
Personally, I don't like to see attachments. Part of it springs from when I
used dialup. I didn't want to see a 500k workbook asking how to add two cells.
In fact, I've chosen to avoid answering posts that include attachments, point at
another site that holds a workbook (or a .jpg of the problem) or is composed in
HTML. But that's just my decision.
But I do think that in most cases, there has to be a description of what needs
to be resolved--with or without an attachment. I also think that many people
will not bother with that description--they'll just take the easy way out and
say "please see sheet2, it doesn't work right".
Another problem is that google won't archive attachments. So as a learning
exercise, as soon as the post ages off whatever servers you use, the
question/responses won't be of much use.
And in the case of your specific example, you, er, the OP was pretty darn lucky
that you opened his workbook as the first workbook in that excel session. Else
you wouldn't have seen how the calculation mode was set.
> The question becomes which is more important: posting the question/answer
> here and all of us learning from it, and I readily admit this is an added
[quoted text clipped - 58 lines]
> > >> am
> > >> able to post the actual spreadsheets to go with the questions?

Signature
Dave Peterson