Sheet that never closes

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
M

Michael Koerner

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
 
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
Click to expand...

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
 
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.
 
Just to clarify.

Personal.xlsb is a workbook, not a worksheet.


Gord Dibben MS Excel MVP
 
Back
Top