Recalculation is an application setting, but it's set by the first workbook you
open in that session. If that first workbook is set for automatic, then excel
will be in automatic mode. If that first workbook is set for manual, then excel
will be in manual mode.
Excel tries to help you. Look at the title bar. You'll see [Group] when sheets
are grouped. Then look at the worksheet tabs. The selected sheets will have a
white background. (This could get more difficult to notice if you're using
xl2002+ and changed the tab color to white!) And if you have lots of sheets,
you may have to scroll right/left to see which ones are grouped.
I don't know anything about that last question.
nastech wrote:
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
--
Dave Peterson