Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How do I fix a workbook.
I have a workbook with 5 sheets and macros with forms. When I select any one
of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill |
#2
|
|||
|
|||
What version of Excel, Bill? Have you tried File--Open and choose the
Repair option? ************ Anne Troy www.OfficeArticles.com "bill" wrote in message ... I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill |
#3
|
|||
|
|||
Anne,
I don't have that option on the file open menu. I have Excel 2002 SP3. -- Bill "Anne Troy" wrote: What version of Excel, Bill? Have you tried File--Open and choose the Repair option? ************ Anne Troy www.OfficeArticles.com "bill" wrote in message ... I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill |
#4
|
|||
|
|||
Bill, I think Anne meant, do File, Open, and then (before anything else) try the Repair option Try the Help column for the Repair (Detect and Repair) option. bill Wrote: Anne, I don't have that option on the file open menu. I have Excel 2002 SP3. -- Bill "Anne Troy" wrote: What version of Excel, Bill? Have you tried File--Open and choose the Repair option? ************ Anne Troy www.OfficeArticles.com "bill" wrote in message ... I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395513 |
#5
|
|||
|
|||
I think you do have that option.
File|Open|select your file But instead of clicking on the Open button, click on that down arrow on that open button. You'll see an "open and repair" option in that popup. bill wrote: Anne, I don't have that option on the file open menu. I have Excel 2002 SP3. -- Bill "Anne Troy" wrote: What version of Excel, Bill? Have you tried File--Open and choose the Repair option? ************ Anne Troy www.OfficeArticles.com "bill" wrote in message ... I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill -- Dave Peterson |
#6
|
|||
|
|||
Dave,
Your explanation was the best. I did fix the file. Thanks. -- Bill "Dave Peterson" wrote: I think you do have that option. File|Open|select your file But instead of clicking on the Open button, click on that down arrow on that open button. You'll see an "open and repair" option in that popup. bill wrote: Anne, I don't have that option on the file open menu. I have Excel 2002 SP3. -- Bill "Anne Troy" wrote: What version of Excel, Bill? Have you tried File--Open and choose the Repair option? ************ Anne Troy www.OfficeArticles.com "bill" wrote in message ... I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill -- Dave Peterson |
#7
|
|||
|
|||
I think I'd open excel in safe mode and try it.
close excel windows start button|run excel /safe file|open your workbook If the problem doesn't occur, maybe it's a macro that's misbehaving. If it does happen, I don't have another guess. bill wrote: I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the only way I can get Excel to stop is to cancel the task. How do I either fix this workbook or copy all the sheets to another workbook? TIA -- Bill -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |