Why does excel create a copy of the worksheet i open

When I open my worksheet named cardlist.xls, excel opens that file but then
calls is cardlist:1 and then creates a copy cardlist:2, but when I save it
only saves as the original file name... what causes this?

You have more than one window open for the workbook. Close one of
the windows.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com






"Renee" <[email protected]> wrote in message
news:[email protected]...
> When I open my worksheet named cardlist.xls, excel opens that
> file but then
> calls is cardlist:1 and then creates a copy cardlist:2, but
> when I save it
> only saves as the original file name... what causes this?

What happened is that you opened 2 windows of the same file and saved, open
the file again
press ctrl + F4, save the file

--

Regards,

Peo Sjoblom


"Renee" <[email protected]> wrote in message
news:[email protected]...
> When I open my worksheet named cardlist.xls, excel opens that file but
then
> calls is cardlist:1 and then creates a copy cardlist:2, but when I save it
> only saves as the original file name... what causes this?

It sounds like you may have inadvertently opened a second instance of
the same file. You can do this (on purpose) by clicking >Window >New.
If you save the file in this format, it reopens with both instances
showing.

Resolve it by clicking the X in the upper right corner of the :2
instance. Save the file, and from then on you'll see only one instance.

Just being picky about semantics, but this isn't "a second instance of the
same file". Two windows means two different views of the same data, not two
copies of the data in memory.

On 2 Mar 2005 08:16:28 -0800, "Dave O" <[email protected]> wrote:

>It sounds like you may have inadvertently opened a second instance of
>the same file. You can do this (on purpose) by clicking >Window >New.
>If you save the file in this format, it reopens with both instances
>showing.
>
>Resolve it by clicking the X in the upper right corner of the :2
>instance. Save the file, and from then on you'll see only one instance.