When I start up Excel, it doesn't start up with book 1, but a quot;personal.xlsquot;
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 quot;personal.xlsquot;?
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?oftnose??ezt ?rta:
gt; When I start up Excel, it doesn't start up with book 1, but a quot;personal.xlsquot;
gt; which if i save my changes, will reappear if I start up Excel next time
gt; round.
gt; How do I get Excel to start up with a fresh book 1 every time and get rid of
gt; this quot;personal.xlsquot;?
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
quot;Stefiquot; wrote:
gt; If you don't need it at all, delete it from
gt; C:\Documents and Settings\yourusername\Application
gt; Data\Microsoft\Excel\XLSTART\
gt; or hide it: Windows/Hide
gt;
gt; Regards,
gt; Stefi
gt;
gt;
gt; ?oftnose??ezt ?rta:
gt;
gt; gt; When I start up Excel, it doesn't start up with book 1, but a quot;personal.xlsquot;
gt; gt; which if i save my changes, will reappear if I start up Excel next time
gt; gt; round.
gt; gt; How do I get Excel to start up with a fresh book 1 every time and get rid of
gt; gt; this quot;personal.xlsquot;?
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/HideStefi
?oftnose??ezt ?rta:
gt; Hi Stefi,
gt;
gt; Thanks for your quick reply, but I can't seem to find the file. It might be
gt; because I am not the administrator, I don't know.
gt; Any way to deactivate it from Excel itself?
gt;
gt; Cheers,
gt; Alex
gt;
gt; quot;Stefiquot; wrote:
gt;
gt; gt; If you don't need it at all, delete it from
gt; gt; C:\Documents and Settings\yourusername\Application
gt; gt; Data\Microsoft\Excel\XLSTART\
gt; gt; or hide it: Windows/Hide
gt; gt;
gt; gt; Regards,
gt; gt; Stefi
gt; gt;
gt; gt;
gt; gt; ?oftnose??ezt ?rta:
gt; gt;
gt; gt; gt; When I start up Excel, it doesn't start up with book 1, but a quot;personal.xlsquot;
gt; gt; gt; which if i save my changes, will reappear if I start up Excel next time
gt; gt; gt; round.
gt; gt; gt; How do I get Excel to start up with a fresh book 1 every time and get rid of
gt; gt; gt; this quot;personal.xlsquot;?
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(quot;Filenamequot;,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:
gt;
gt; When I start up Excel, it doesn't start up with book 1, but a quot;personal.xlsquot;
gt; which if i save my changes, will reappear if I start up Excel next time
gt; round.
gt; How do I get Excel to start up with a fresh book 1 every time and get rid of
gt; this quot;personal.xlsquot;?
--
Dave Peterson
- Nov 21 Wed 2007 20:40
Starting up with Book 1
close
全站熱搜
留言列表
發表留言