Sheet that never closes

[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

 

[Master Blaster]

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

 

[Michael Koerner]

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.

 

[Gord Dibben]

Just to clarify.

Personal.xlsb is a workbook, not a worksheet.


Gord Dibben MS Excel MVP

 

[Michael Koerner]

typo on my part

Just to clarify.

Personal.xlsb is a workbook, not a worksheet.


Gord Dibben MS Excel MVP