Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Renee
 
Posts: n/a
Default 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?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

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?



  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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?



  #4   Report Post  
Dave O
 
Posts: n/a
Default

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.

  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 11:05 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 1 February 10th 05 09:20 PM
Create New Microsoft Excel Worksheet Has 3 Sheets Bassam Setting up and Configuration of Excel 0 February 9th 05 08:51 PM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"