Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Starting up with Book 1
When I start up Excel, it doesn't start up with book 1, but a "personal.xls"
which if i save my changes, will reappear if I start up Excel next time round. How do I get Excel to start up with a fresh book 1 every time and get rid of this "personal.xls"? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Starting up with Book 1
If you don't need it at all, delete it from
C:\Documents and Settings\yourusername\Application Data\Microsoft\Excel\XLSTART\ or hide it: Windows/Hide Regards, Stefi €˛softnose€¯ ezt Ć*rta: When I start up Excel, it doesn't start up with book 1, but a "personal.xls" which if i save my changes, will reappear if I start up Excel next time round. How do I get Excel to start up with a fresh book 1 every time and get rid of this "personal.xls"? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Starting up with Book 1
Hi Stefi,
Thanks for your quick reply, but I can't seem to find the file. It might be because I am not the administrator, I don't know. Any way to deactivate it from Excel itself? Cheers, Alex "Stefi" wrote: If you don't need it at all, delete it from C:\Documents and Settings\yourusername\Application Data\Microsoft\Excel\XLSTART\ or hide it: Windows/Hide Regards, Stefi €˛softnose€¯ ezt Ć*rta: When I start up Excel, it doesn't start up with book 1, but a "personal.xls" which if i save my changes, will reappear if I start up Excel next time round. How do I get Excel to start up with a fresh book 1 every time and get rid of this "personal.xls"? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Starting up with Book 1
Application Data\ is a hidden folder by default! You can display it via
My Computer/Tools/Folder Settings/View/Hidden files and folders, check the display option button! Or try the second method from Excel: Windows/Hide Stefi €˛softnose€¯ ezt Ć*rta: Hi Stefi, Thanks for your quick reply, but I can't seem to find the file. It might be because I am not the administrator, I don't know. Any way to deactivate it from Excel itself? Cheers, Alex "Stefi" wrote: If you don't need it at all, delete it from C:\Documents and Settings\yourusername\Application Data\Microsoft\Excel\XLSTART\ or hide it: Windows/Hide Regards, Stefi €˛softnose€¯ ezt Ć*rta: When I start up Excel, it doesn't start up with book 1, but a "personal.xls" which if i save my changes, will reappear if I start up Excel next time round. How do I get Excel to start up with a fresh book 1 every time and get rid of this "personal.xls"? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Starting up with Book 1
Lots of people use personal.xls to store macros that they want available
whenever they open excel. And most people keep that workbook hidden. If you want this: With personal.xls the activeworkbook, click on Window|Hide then close excel. You'll be prompted to save personal.xls in that hidden state. If you really don't want personal.xls and you don't know where it is, you can: Open excel. Put this formula in an empty cell in personal.xls: =cell("Filename",a1) You'll see the drive/folder/filename/sheet name. Make a note of it. Close excel and use windows explorer to delete (or just move???) that file. === Or with personal.xls open: file|properties|general tab and you'll see the location there. softnose wrote: When I start up Excel, it doesn't start up with book 1, but a "personal.xls" which if i save my changes, will reappear if I start up Excel next time round. How do I get Excel to start up with a fresh book 1 every time and get rid of this "personal.xls"? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
book selection when using move or copy tab in excel | Excel Worksheet Functions | |||
how to get an value from a different book | Excel Discussion (Misc queries) | |||
Work book formulas | Excel Discussion (Misc queries) | |||
Best Book for an Investment Banker to Learn Excel | Excel Discussion (Misc queries) | |||
Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions |