Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to change excel 2007 default name

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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to change excel 2007 default name

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)

maul_pawar wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the default 'user' name in excel 2007 MickCarr Excel Discussion (Misc queries) 2 November 13th 08 06:01 PM
how do i change default font for comments in excel 2007? andy f Excel Discussion (Misc queries) 1 September 24th 08 06:25 AM
How do I change default symbols in Excel 2007? Fox Unit 1 Excel Discussion (Misc queries) 2 March 13th 08 07:51 PM
How do I change the Default directories in 2007 Word and Excel Therogre Excel Discussion (Misc queries) 4 October 15th 07 11:46 PM
Change default gridline color in Excel 2007 Michael Pass Excel Discussion (Misc queries) 2 June 6th 06 02:17 AM


All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"