N
nastech
Can no longer access comments to: edit, copy-paste, nor paste-special.
Did I hit a wrong key? thanks
Did I hit a wrong key? thanks
D
Dave Peterson
Is your worksheet protected?
Do you have multiple worksheets grouped?
Do you have multiple worksheets grouped?
N
nastech
thanks, you hit it, found it myself this morn, some how grouped a couple of
worksheets. 1 click fix
thanks
worksheets. 1 click fix
thanks
N
nastech
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.
have to work on it tomarrow. what did was some surgery, moved columns
around, accidently hit groups... I'll get it, thanks for help.
D
Dave Peterson
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.
I'd check is:
Tools|Options|calculation tab
make sure automatic is checked.
G
Gord Dibben
nastech
When two or more sheets are grouped, what you do to one is done to all.
During your surgery you were working on more than one sheet.
No udo for this. You will have to redo your steps if you can.
Gord Dibben Excel MVP
When two or more sheets are grouped, what you do to one is done to all.
During your surgery you were working on more than one sheet.
No udo for this. You will have to redo your steps if you can.
Gord Dibben Excel MVP
N
nastech
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
(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
N
nastech
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
(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
D
Dave Peterson
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.
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.