Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jakethedog
 
Posts: n/a
Default How do I shut off a second version (xls:2) of a worksheet?

Somehow I have a file:

filename v.1.0.XLS:1

that shows a duplicate copy:

filename v.1.1.XLS:2

every time I open it. I have searched the pull down menus and online
documentation, but can NOT find how to resolve this and return to a single
file version.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default How do I shut off a second version (xls:2) of a worksheet?

You have multiple windows into that single workbook.

Select the window you don't want and hit ctrl-w.

Then save the workbook.

jakethedog wrote:

Somehow I have a file:

filename v.1.0.XLS:1

that shows a duplicate copy:

filename v.1.1.XLS:2

every time I open it. I have searched the pull down menus and online
documentation, but can NOT find how to resolve this and return to a single
file version.


--

Dave Peterson
  #3   Report Post  
jakethedog
 
Posts: n/a
Default How do I shut off a second version (xls:2) of a worksheet?

simple, concise and most importantly, effective - thank YOU!!

"Dave Peterson" wrote:

You have multiple windows into that single workbook.

Select the window you don't want and hit ctrl-w.

Then save the workbook.

jakethedog wrote:

Somehow I have a file:

filename v.1.0.XLS:1

that shows a duplicate copy:

filename v.1.1.XLS:2

every time I open it. I have searched the pull down menus and online
documentation, but can NOT find how to resolve this and return to a single
file version.


--

Dave Peterson

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
macro to copy and edit then delete a worksheet lschuh Excel Discussion (Misc queries) 13 July 27th 05 09:02 PM
help! making a worksheet more automated? redb Excel Discussion (Misc queries) 2 April 15th 05 01:53 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 02:55 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 06:10 PM


All times are GMT +1. The time now is 07:39 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"