Unwanted sheets

  • Thread starter Thread starter Jules
  • Start date Start date
J

Jules

My Excel operation has changed so that every time I call
up a worksheet--any worksheet--the program brings up some
recently-created worksheets, stacks them and places the
requested sheet on top, but free-floating, and without
the formula display, making it useful for only trivial
stuff.
When the sheet is saved or deleted, the unwanted sheets
also must be separately dealt with. (One of them is
always labled "Personal".) I can't delete them, or find
them with Explorer.
 
Anything you have in your XLSTART directory will be opened
by Excel. If you put anything into
tools, options, General, Alternate Startup location
it will also be opened Excel opens, and is generally a mistake.

Your personal.xls file should be in your XLSTART directory
generally created for you by Excel when you record a macro
and ask for it to be put into your personal file.
The file should be hidden though.
Window, Hide, <select personal.xls>

If you do Window, Unhide
you should only see personal.xls as a choice, for most people.

Close all the other files, except the one you want to work with
Maximize the file, then save

If you use Window, new Window
you will get another view of your file and you will see a colon and number
i.e. xenu.xls:2 on the title bar
it is just another view of xenu.xls when through with the view simply
close the file with the upper right [x] on the file window within the Excel window.
 
Back
Top