Actually, excel won't include the .xls extension on the file until the workbook
has been saved.
The default name for the first (unsaved) workbook will be Book1 (without that
extension).
Guy Lydig wrote:
>
> First of all, why do you have a document named Book1.xls? That is the default
> name Excel gives to a new document. When you save, you should give the
> workbook a different name--one that is meaningful to you and describes the
> contents of the workbook.
>
> Secondly: there is no "problem". Like it or not, this is Excel's quirk: you
> CANNOT open 2 workbooks with the same name whether or not they are in the
> same folder or drive. If you have a workbook called Book1 open, you cannot
> open another workbook called Book1. The solution is to close the first one
> before you open the second one. OR, you can rename the second one before you
> open it.
>
> Again--name your workbooks anything but the default name or you are looking
> for mass confusion.
>
> HTH
>
> Guy
>
> "Sentry11" wrote:
>
> >
> > A DOCUMENT WITH THE NAME \"BOOK1.XLS\" IS ALREADY OPENED. YOU CANNOT
> > OPEN TWO DOCUMENTS WITH THE SAME NAME, EVEN IF THE DOCUMENT ARE IN
> > DIFFERENT FOLDERS.
> > TO OPEN THE SECOND DOCUMENT, EITHER CLOSE THE DOCUMENT THAT'S CURRENTLY
> > OPEN, OR RENAME ONE OF THE DOCUMENTS.
> >
> > What's the root of the problem with this error message? Any help will
> > be greatly appreciated.
> >
> >
> >
> >
> > --
> > Sentry11
> >
--
Dave Peterson
Bookmarks