| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet that never closes
I have an Excel sheet that I've had since version 95. For this explanation I
will call it Names. If I open Names make changes save and close Names but remain in Excel and open another sheet. The sheet Names will automatically open again and when I shut down Excel will ask me if I want to save Names again. I have no idea why. If I close Names, exit Excel, then reopen Excel and open another sheet the above does not happen. Sometimes it can be a PITA. Regards Michael Koerner |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet that never closes
On Jan 31, 2:02*pm, "Michael Koerner" wrote:
I have an Excel sheet that I've had since version 95. For this explanation I will call it Names. If I open Names make changes save and close Names but remain in Excel and open another sheet. The sheet Names will automatically open again and when I shut down Excel will ask me if I want to save Names again. I have no idea why. If I close Names, exit Excel, then reopen Excel and open another sheet the above does not happen. Sometimes it can be a PITA. Regards Michael Koerner Try to see if the sheet is hidden after you close it. Unhide the workbook and close it. It somethimes helps. Otherwise, I think it there is a bug in the sheet. Try to copy the contents to an other sheet and save it there. Hope it works Regards |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet that never closes
The only sheet that is hidden after I close it is Personal.xlsb Have tried
copying to another sheet. that does not seem to matter. -- Regards Michael Koerner "Master Blaster" wrote in message ... On Jan 31, 2:02 pm, "Michael Koerner" wrote: I have an Excel sheet that I've had since version 95. For this explanation I will call it Names. If I open Names make changes save and close Names but remain in Excel and open another sheet. The sheet Names will automatically open again and when I shut down Excel will ask me if I want to save Names again. I have no idea why. If I close Names, exit Excel, then reopen Excel and open another sheet the above does not happen. Sometimes it can be a PITA. Regards Michael Koerner Try to see if the sheet is hidden after you close it. Unhide the workbook and close it. It somethimes helps. Otherwise, I think it there is a bug in the sheet. Try to copy the contents to an other sheet and save it there. Hope it works Regards |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet that never closes
Just to clarify.
Personal.xlsb is a workbook, not a worksheet. Gord Dibben MS Excel MVP On Sun, 31 Jan 2010 15:12:37 -0500, "Michael Koerner" wrote: The only sheet that is hidden after I close it is Personal.xlsb Have tried copying to another sheet. that does not seem to matter. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sheet that never closes
typo on my part
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Just to clarify. Personal.xlsb is a workbook, not a worksheet. Gord Dibben MS Excel MVP On Sun, 31 Jan 2010 15:12:37 -0500, "Michael Koerner" wrote: The only sheet that is hidden after I close it is Personal.xlsb Have tried copying to another sheet. that does not seem to matter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 closes when e-mailing sheet | Excel Discussion (Misc queries) | |||
| Excel never closes | Excel Discussion (Misc queries) | |||
| WHY THIS CLOSES EXCEL IF THERE´S NO SHEET NAMED AS...??? | Excel Programming | |||
| when i insert word art in excel sheet excel file closes automatica | Excel Discussion (Misc queries) | |||
| Enabling Add-In closes current sheet | Excel Programming | |||
Linear Mode
