thanks for the replies, some small questions, checking before hitting send:
(funny, had book for while, all 3 points in 1st part of 1st chapter:
groups, recalc, today() & now()/ macros: Excel Hacks, Hawley)

- I suppose when file opens, doesn't matter hitting "NO" to macro's if know
performing "surgery"? (read (2) date columns script, for today() & now(),
can cause havoc: notice recalc in options was turned off, not sure how that
happened)

- have backup file, will redo changes from scratch if have to, but is
there a way to see what sheets are grouped during groups? after groups?
(have backup file with group set as had happened; Instead of redoing
changes, easier to paste other sheets into file (were / are
non-related/non-linked sheets: things seem to be working again)

- I am starting to learn about automating web info into XL. Seems to be
not so referencable / preset-easy task. Is there a preferred method? (am
willing to share sheet with info that I have) Thanks for all the help. Info
have or guesse to understand:

- download to a separate sheet & somehow import/link; or can I download
directly to my sheet? Iis that more programming than should do now?
- found group was just able to get into (did not think existed):
http://groups.yahoo.com/group/xltraders/
- found metastock, but need my spreadsheet to work

"Dave Peterson" wrote:

If the workbook isn't recalculating when you think it should, the first place
I'd check is:

Tools|Options|calculation tab
make sure automatic is checked.

nastech wrote:

bummer, now any data I enter no action in calc'd fields, maybe corrupted?
have to work on it tomarrow. what did was some surgery, moved columns
around, accidently hit groups... I'll get it, thanks for help.

"Dave Peterson" wrote:

Is your worksheet protected?

Do you have multiple worksheets grouped?

nastech wrote:

Can no longer access comments to: edit, copy-paste, nor paste-special.
Did I hit a wrong key? thanks

--

Dave Peterson


--

Dave Peterson