How to change excel 2007 default name

M

maul_pawar

i have office 2007 and some how my default excel name change from Book1 to
Personal. can you help me change default name ...
 
D

Dave Peterson

Personal.xls* is the name lots (most) people use for the workbook that contains
common macros that they want available each time they start excel.

If you don't have macros (or no one gave you a file with macros), then you can
delete this file.

If you want to delete it:
Open excel
with personal.* the active workbook, put this in A1 of the activesheet.
=cell("Filename",a1)
(don't change anything)

Make a note of the file's location.

Close excel and then use windows explorer to traverse to that drive/folder and
delete the file.

=======
On the other hand, if you want this workbook (because of your macros), then
you'll want to keep the file, but hide it from view.

in xl2003 menus, you'd:
activate that workbook
window|hide window
close excel and save the file on the way out (you'll be prompted)

In xl2007, it's:
View tab (on the ribbon)
Window Group
Hide icon
close excel and save the file on the way out (you'll be prompted)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top