Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
Can no longer access comments to: edit, copy-paste, nor paste-special.
Did I hit a wrong key? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
thanks, you hit it, found it myself this morn, some how grouped a couple of
worksheets. 1 click fix :) thanks "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 On Wed, 21 Dec 2005 12:32:02 -0800, "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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
comments access gone??
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 "Gord Dibben" wrote: 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 On Wed, 21 Dec 2005 12:32:02 -0800, "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
Excel and Access talking | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |