Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hourglass won't go away after formula was entered
This question is for my husband. He's at home working on a homework
assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#2
|
|||
|
|||
hourglass won't go away after formula was entered
Try the ESC key or hold CTRL and press Break key
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dawn" wrote in message ... This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#3
|
|||
|
|||
hourglass won't go away after formula was entered
?????
Formulas? Commands? Any Macros? Multiple Workbooks? Tell us about the 3 hours of work! How are we supposed to assist in any way if we have no clue whatsoever about what your husband was doing? -- Kind regards, Niek Otten "Dawn" wrote in message ... This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#4
|
|||
|
|||
hourglass won't go away after formula was entered
Hi Dawn
Maybe Ctrl+Shift+Break. Perhaps he has got a macro that has got into an endless loop. Regards Roger Govier Dawn wrote: This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#5
|
|||
|
|||
hourglass won't go away after formula was entered
Please be patient..... we are both new to this.
He said the formula he entered was for a column. He was trying to get the outcome of high, low, average totals. "Niek Otten" wrote: ????? Formulas? Commands? Any Macros? Multiple Workbooks? Tell us about the 3 hours of work! How are we supposed to assist in any way if we have no clue whatsoever about what your husband was doing? -- Kind regards, Niek Otten "Dawn" wrote in message ... This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#6
|
|||
|
|||
hourglass won't go away after formula was entered
Hi Roger! Nope, that didn't work. Thanks!!!
"Roger Govier" wrote: Hi Dawn Maybe Ctrl+Shift+Break. Perhaps he has got a macro that has got into an endless loop. Regards Roger Govier Dawn wrote: This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#7
|
|||
|
|||
hourglass won't go away after formula was entered
Hi Dawn,
I didn't mean to hurry you! But it would help if you would give some more details. -- Kind regards, Niek Otten "Dawn" wrote in message ... Please be patient..... we are both new to this. He said the formula he entered was for a column. He was trying to get the outcome of high, low, average totals. "Niek Otten" wrote: ????? Formulas? Commands? Any Macros? Multiple Workbooks? Tell us about the 3 hours of work! How are we supposed to assist in any way if we have no clue whatsoever about what your husband was doing? -- Kind regards, Niek Otten "Dawn" wrote in message ... This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#8
|
|||
|
|||
hourglass won't go away after formula was entered
Hi Dawn
Well hopefully Autosave is switched on and is at the default setting of 10 minutes. If so, should he have to close the file he will only lose the last 10 minutes work prior to the problem. Regards Roger Govier Dawn wrote: Hi Roger! Nope, that didn't work. Thanks!!! "Roger Govier" wrote: Hi Dawn Maybe Ctrl+Shift+Break. Perhaps he has got a macro that has got into an endless loop. Regards Roger Govier Dawn wrote: This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#9
|
|||
|
|||
hourglass won't go away after formula was entered
Someone else mentioned that to me.....how can we tell if autosave is switched
on or not?? If it is on he'll be happy to shut it down. Thanks again! "Roger Govier" wrote: Hi Dawn Well hopefully Autosave is switched on and is at the default setting of 10 minutes. If so, should he have to close the file he will only lose the last 10 minutes work prior to the problem. Regards Roger Govier Dawn wrote: Hi Roger! Nope, that didn't work. Thanks!!! "Roger Govier" wrote: Hi Dawn Maybe Ctrl+Shift+Break. Perhaps he has got a macro that has got into an endless loop. Regards Roger Govier Dawn wrote: This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
#10
|
|||
|
|||
hourglass won't go away after formula was entered
Dawn
Depends which version of Excel you are running. Versions earlier than 2002 had an AutoSave Add-in under ToolsAdd-ins which when turned on saved incremental backups at intervals, usually 10 minutes. 2002 and 2003 have an "AutoRecovery" feature which does not save incremental backups, but does store a recovery file at intervals you set under ToolsOptionsSave. If Excel crashes you would be offered a chance to use that recovery file next time you open Excel. I believe a CAD classifies as a crash but not 100% certain. Shutting down the computer cold would qualify. Lotsa luck. Gord Dibben Excel MVP On Tue, 1 Nov 2005 11:56:01 -0800, "Dawn" wrote: Someone else mentioned that to me.....how can we tell if autosave is switched on or not?? If it is on he'll be happy to shut it down. Thanks again! "Roger Govier" wrote: Hi Dawn Well hopefully Autosave is switched on and is at the default setting of 10 minutes. If so, should he have to close the file he will only lose the last 10 minutes work prior to the problem. Regards Roger Govier Dawn wrote: Hi Roger! Nope, that didn't work. Thanks!!! "Roger Govier" wrote: Hi Dawn Maybe Ctrl+Shift+Break. Perhaps he has got a macro that has got into an endless loop. Regards Roger Govier Dawn wrote: This question is for my husband. He's at home working on a homework assingment in excel. He said he entered a formula then the hour glass came up and it hasn't gone away. He can't close without saving. He's going to have to shut the system down without saving 3 hours of work. Any suggestions? Thanks for you time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel |