| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete unwanted sheet
When I bring up any excel sheet that i created and go to close it out it
brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
Hi Brenda,
I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
I understand the difference it is a totally seperate workbook i don't know
why it keeps coming up -- Thank you, Brenda "OssieMac" wrote: Hi Brenda, I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
What is the name of the workbook which comes up? If it matches the name of
any add-in then try to disable that. If not then check whether that file is in your XLSTART folder... Excel 2003 default location... C:\Program Files\Microsoft Office\OFFICE11\XLSTART Excel version? -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Brenda" wrote: I understand the difference it is a totally seperate workbook i don't know why it keeps coming up -- Thank you, Brenda "OssieMac" wrote: Hi Brenda, I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
okay i checked and it is not in my start up. i am using excel 2003. It is
names Personal.xls. It is funny because no matter what excel spreadsheet i bring up when i close it, it brings that up and i have to close that too. Any other suggestions? -- Thank you, Brenda "Sheeloo" wrote: What is the name of the workbook which comes up? If it matches the name of any add-in then try to disable that. If not then check whether that file is in your XLSTART folder... Excel 2003 default location... C:\Program Files\Microsoft Office\OFFICE11\XLSTART Excel version? -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Brenda" wrote: I understand the difference it is a totally seperate workbook i don't know why it keeps coming up -- Thank you, Brenda "OssieMac" wrote: Hi Brenda, I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
Did you look in
C:\Program Files\Microsoft Office\OFFICE11\XLSTART ? Close Excel Search for personal.xls and delete it Your problem should be resolved... If you want to retain it then when personal.xls opens - choose Window|Hide and then close Excel. When prompted to save Personal macro workbook, click Yes. FYI - personal.xls is used to store macro which you want to be available in all files... somehow it has got into your system... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Brenda" wrote: okay i checked and it is not in my start up. i am using excel 2003. It is names Personal.xls. It is funny because no matter what excel spreadsheet i bring up when i close it, it brings that up and i have to close that too. Any other suggestions? -- Thank you, Brenda "Sheeloo" wrote: What is the name of the workbook which comes up? If it matches the name of any add-in then try to disable that. If not then check whether that file is in your XLSTART folder... Excel 2003 default location... C:\Program Files\Microsoft Office\OFFICE11\XLSTART Excel version? -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Brenda" wrote: I understand the difference it is a totally seperate workbook i don't know why it keeps coming up -- Thank you, Brenda "OssieMac" wrote: Hi Brenda, I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete unwanted sheet
Hi Brenda,
You might ask - where did this come from? If you record a macro, one of the options is to store that macro in the Personal Macro Workbook. If you choose that options, Excel immediately creates a file called Personal.xls and when you first close out it askes you to save it. If you reponded yes Excel will now open the Personal.xls file automatically everytime you start Excel. The Personal Macro Workbook is machine specific so to speak, so if someone used your machine before you, or while you were away, they might have created the file. Normally this workbook is hidden so you don't see its sheet, however, you can choose Window, Unhide and display it. If you then exit Excel you will be asked if you want to save it, if you respond Yes, it will be visible everytime you open Excel. Now, I know its probably too late, but before you delete it from the \XLStart folder you should consider whether it contains any macros you want/need. For example, has anyone created a macro for you to help you do some task easily? If so they may have put it into the Personal.xls file. If any of this is helpful,, please click the Yes button. -- Thanks, Shane Devenshire "Brenda" wrote: okay i checked and it is not in my start up. i am using excel 2003. It is names Personal.xls. It is funny because no matter what excel spreadsheet i bring up when i close it, it brings that up and i have to close that too. Any other suggestions? -- Thank you, Brenda "Sheeloo" wrote: What is the name of the workbook which comes up? If it matches the name of any add-in then try to disable that. If not then check whether that file is in your XLSTART folder... Excel 2003 default location... C:\Program Files\Microsoft Office\OFFICE11\XLSTART Excel version? -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Brenda" wrote: I understand the difference it is a totally seperate workbook i don't know why it keeps coming up -- Thank you, Brenda "OssieMac" wrote: Hi Brenda, I think you might be confusing Worksheets with Workbooks. Workbooks are the actual Excel file with 1 or more Worksheets (tabs across the bottom). Now in a Workbook, there must be at least 1 visible worksheet. If you try to either delete or hide the last visible worksheet you get a message similar to what you describe but it says this WORKBOOK (not worksheet) must contain....etc. -- Regards, OssieMac "Brenda" wrote: When I bring up any excel sheet that i created and go to close it out it brings up another sheet that i have to close out. I don't know how this sheet got put in but when i go to delete it i get a pop up message saying: this worksheet must contain at least one visible worksheet;you must first insert a new sheet or unhide a sheet that is already hidden. How can i get this sheet out and delete it. No matter what excel sheet i bring up i always get this now. Please help -- Thank you, Brenda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete unwanted data | Excel Worksheet Functions | |||
| macro to delete unwanted data | Excel Discussion (Misc queries) | |||
| Macro to delete unwanted sheets | Excel Discussion (Misc queries) | |||
| Delete unwanted page breaks. | Excel Worksheet Functions | |||
| Delete Unwanted Data | Excel Discussion (Misc queries) | |||
Hybrid Mode
