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" wrote in message
...
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" wrote in message
...
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" 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.