Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default duplicate workbooks open while working in that file

After having opened a workbook and entering data, a second and third
duplicate workbook opens while i'm still in the original workbook. Any
suggestions on how to correct this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default duplicate workbooks open while working in that file

Sounds like you're looking at several "windows" of the same workbook. Does
the workbook name end in :1 and :2 and :3? If so, close the workbook WITH THE
X in the upper right corner. When this makes the :x disappear, save the
workbook

"rob86021" wrote:

After having opened a workbook and entering data, a second and third
duplicate workbook opens while i'm still in the original workbook. Any
suggestions on how to correct this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default duplicate workbooks open while working in that file

Are you saying that only the one workbook opens at first then later sometime you
get two duplicates come popping up?

Do these workbooks have a filename like myworkbook.xls:1 and myworkbook.xls:2
etc.?

In the latter case you have inadvertantly gone to WindowNew Window and created
new windows of that workbook.

Close the ones you don't want by hitting the "x" on the book title bar.

When you get down to one copy only, save.


Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 13:05:01 -0700, rob86021
wrote:

After having opened a workbook and entering data, a second and third
duplicate workbook opens while i'm still in the original workbook. Any
suggestions on how to correct this?


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
file open details option stopped working Charter School Setting up and Configuration of Excel 3 August 18th 06 09:42 PM
When I open Excel, workbooks open automatically. How can I stop t Rhealbird Excel Discussion (Misc queries) 2 February 23rd 06 10:08 AM
Vlookup not working because of duplicate matches BBS Excel Worksheet Functions 8 February 3rd 06 11:39 AM
duplicate workbooks Duplicate workbooks Excel Discussion (Misc queries) 2 January 12th 06 11:32 PM
how do I compare workbooks for duplicate data mlarson47 Excel Discussion (Misc queries) 1 April 29th 05 07:00 PM


All times are GMT +1. The time now is 03:05 AM.

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

About Us

"It's about Microsoft Excel"