Shane
Sat Mar 15 09:43:39 CDT 2008
This is a multi-part message in MIME format.
------=_NextPart_000_0047_01C88670.48A87D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Expanding on the two previous suggestions since you may not know where =
the default workbook is kept or how to modify it:
The default workbook, which is usually named Book.xlt is generally =
located in the C:\Program Files\Microsoft Office\Office 11\XLStart =
folder. (note Office 11 is just one possibility depending on the =
version of Excel you are using.) You can always do a window's search =
for XLStart.
Open the file in Excel using File, Open. Modify the file as necessary - =
1. Unhide Sheet1 if its hidden, 2. Add Sheet1 if it has been deleted.
There is one other possible cause of your problem - there could be a =
Workbook_Open macro that either hides or deletes sheet1 every time you =
open the file. This could be located in the Book.xlt file, the Personal =
Macro Workbook, or some add-in.
Cheers,
Shane Devenshire
Microsoft Excel MVP
"afdmello" <afdmello@hotmail.com> wrote in message =
news:uWLKzHqhIHA.4844@TK2MSFTNGP06.phx.gbl...
> whenever I open excel the new workbook has 2 sheets named as sheet 2 =
and=20
> sheet3 why not sheet1 and 2 and 3.
>=20
> afd=20
>=20
>
------=_NextPart_000_0047_01C88670.48A87D80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dunicode">
<META content=3D"MSHTML 6.00.6000.16609" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Expanding on the two previous =
suggestions since you=20
may not know where the default workbook is kept or how to modify=20
it:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The default workbook, which is usually =
named=20
Book.xlt is generally located in the C:\Program Files\Microsoft =
Office\Office=20
11\XLStart folder. (note Office 11 is just one possibility =
depending on=20
the version of Excel you are using.) You can always do a window's =
search=20
for XLStart.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Open the file in Excel using File, =
Open. =20
Modify the file as necessary - 1. Unhide Sheet1 if its hidden, 2. Add =
Sheet1 if=20
it has been deleted.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>There is one other possible cause of =
your problem -=20
there could be a Workbook_Open macro that either hides or deletes sheet1 =
every=20
time you open the file. This could be located in the Book.xlt =
file, the=20
Personal Macro Workbook, or some add-in.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Cheers,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Shane Devenshire</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Microsoft Excel MVP</FONT></DIV>
<DIV><BR><BR>"afdmello" <afdmello@hotmail.com> wrote in message=20
news:uWLKzHqhIHA.4844@TK2MSFTNGP06.phx.gbl...<BR>> whenever I open =
excel the=20
new workbook has 2 sheets named as sheet 2 and <BR>> sheet3 why not =
sheet1=20
and 2 and 3.<BR>> <BR>> afd <BR>> <BR>></DIV></BODY></HTML>
------=_NextPart_000_0047_01C88670.48A87D80--